Forum

Welcome Guest! To enable all features please try to register or login.
Sprememba pozicij-postavk v naročilu
Options Go to last post Go to first unread
Previous Topic Next Topic
Default
#1 Posted: : 01 September 2011 19:34:59(UTC)
Default

Rank: Advanced Member

You have been a member since:: 01/09/2011(UTC)
Objave: 33

Thanks: 1 times
Zdravo,

Imam težavo nekdo mi je nekaj spremenil v naročilu kupcev in sicer postavko v poziciji 'rok dobave'

Moje vprašanje
Ali je možno s poizvedbo v SQL priti do te tabele da bi videl zadnjo spremembo oz uporabnikov 'anuserid'?

Hvala
sebastijan
#2 Posted: : 01 September 2011 19:40:13(UTC)
sebastijan

Rank: PA User

You have been a member since:: 24/04/2009(UTC)
Objave: 334
Man
Lahko, v kolikor imate vklopljeno beleženje sprememb.


SELECT * FROM tHE_OrderItem_Undo WHERE acKey = 'ŠTEVILKA DOKUMENTA'
Default
#3 Posted: : 01 September 2011 19:54:13(UTC)
Default

Rank: Advanced Member

You have been a member since:: 01/09/2011(UTC)
Objave: 33

Thanks: 1 times
Probal sem zagnati

SELECT * FROM tHE_OrderItem_Undo

Pa mi vrže napako Invalid object name 'tHE_OrderItem_Undo'

A je krivo da nimam vkljopljeno beleženje sprememb? Kje se to vklopi?

Lp
DAMIJANK
#4 Posted: : 02 September 2011 08:24:35(UTC)
DAMIJANK

Rank: DL Partner

You have been a member since:: 24/04/2009(UTC)
Objave: 82

Was thanked: 2 time(s) in 1 post(s)
Da, napako javi, ker nimate vklopljenega logiranja. Vklopi se v Administratorski konzoli - Podatkovna baza - Nastavitev loga sprememb

kdo pa je zadnji delal spremembo pa se vidi tudi v klasični tabeli the_Orderitem , polje anUserChg in adTimeChg - ne vidi pa se kaj je delal.


____________________________________________________________________________________________________________



Ulica Vita Kraigherja 10
2000 Maribor
www.asistent.si -> DataLab PREMIUM Partner

Edited by user 05 September 2011 09:08:03(UTC)  | Reason: Not specified
Default
#5 Posted: : 28 October 2011 10:24:30(UTC)
Default

Rank: Advanced Member

You have been a member since:: 01/09/2011(UTC)
Objave: 33

Thanks: 1 times
Vklopil sem si logo za spremembe za tabelo personalne mape tHR_Prsn..

Kako naj recimo zdaj to pogledem ..kje je ta logo sprememb? kako to zaženem?
dejan
#6 Posted: : 28 October 2011 11:53:05(UTC)
dejan

Rank: PA User

You have been a member since:: 24/04/2009(UTC)
Objave: 579
Man

Was thanked: 9 time(s) in 9 post(s)
Tako kot ti je napisal Damjan..

Druače pa tudi v AK -- nastavitve logiranja... lahko stisnes na *_undo tabelo in se ti bo odprla..
Vobo d.o.o.
Na gorci 66
2000 Maribor
www.vobo.si
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2026, Yet Another Forum.NET
This page was generated in 0,589 seconds.