translate code Navision to code Sql

hugoisti

hello to all, I need to know whether there is any way see the code generated in Navision translated in code SQL.
many thanks for his help.

bbrown

Not quite sure what you are asking here. The code does not get "translated". The NAV client does generate and execute SQL statements as a result of the NAV code. If you want to see these use the Client Monitor.

hugoisti

ok, if that option the was watching, but no some other way?
thank you!!!!

garak

Open the SQL Profiler, filter for your SPID. Then you see the SQL Code which the NAV Client genereates.
Also possible, open the Client Monitor and recording your activity, you can see the SQL statements (requ. the enhanced Client Monitor).
To get the enhanced CM got to PartnerSource.

Regards

Malajlo

Hmmmm, several years ago I've used SQL trace (we had some problems using '-' in code field).

hugoisti

many thanks for your help, I was greatly facilitated the work of analysis that she had to do, I thank again all by answering