Backend Table

[ITSEI]

I would like to be able to track through the backend sql tables transactions. For instance if we receive in a PO, i want to be able to track every instance of changes on the table level. Is there any way to do that?

 

[BobSchleicher]

Close your GP client then edit your dex.ini in your GP install folder and change these values:

SQLLogODBCMessages=FALSE
SQLLogAllODBCMessages=FALSE

from FALSE to TRUE.

This will create a Dex.log file that will probably give you what you need.

You can delete this log at any time, this is good if you want to see what a particular transaction will do. Such as: What happens after you hit save on a sales order? Get to a point where you are ready to hit save, goto the install folder and delete the dex.log, then hit save. Now you have a clean log that shows what happens after you hit save.

BobSchleicher

 

[jazgeek]

create an insert/update/delete trigger on the required tables and populate a user defined table with the data you require.

I do that to catch salesmen changing dates on sales orders without getting it approved.



-----------
and they wonder why they call it Great Pains!

jaz

 

[VictoriaYudin]

You can also use SQL Profiler to do this....

 

[ITSEI]

sweet thx Bob, that will deffinatly help out. Not that experianced yet with reading the logs, but this will at least help get me in the right direction.

How do you use SQL Profiler? and where do i get it?

 

[VictoriaYudin]

If you have SQL Server installed, most likely you have Profiler installed, it comes with SQL Server. There is a section in the SQL Books Online (also usually installed with SQL Server) that goes over how to use Profiler. If you're talking about tracking every change at the table level of SQL, it's probably not a bad idea to take a look at Profiler.

 

[ITSEI]

cool thx something new to mess with