CAL code to SQL Query

vicky_dada

Hi Guys,

Can anyone please tell me which process changes CAL to SQL query in SQL server option installation?

In a simple lang, even if we add a new field in any form, a sql query executed, I would like to know where exacty all the actions are changed to sql queries

Marije_Brummel

There is a dll file that handles the conversion.

More info: http://dynamicsuser.net/blogs/waldo/arc ... n-sql.aspx

matttrax

You'll notice that NAV still does a SELECT * every time it needs anything from the database. I hope they fix this one day.

kine

vicky dada wrote:

Hi Guys,

Can anyone please tell me which process changes CAL to SQL query in SQL server option installation?

In a simple lang, even if we add a new field in any form, a sql query executed, I would like to know where exacty all the actions are changed to sql queries

If you mean where is the code, which really translate the C/AL into SQL, that it is in compiled dll file. Why you need that? You cannot change the way how the SQL is generated...

David_Singleton

matttrax wrote:

You'll notice that NAV still does a SELECT * every time it needs anything from the database. I hope they fix this one day.

like this maybe...
Select * FROM and how to do it better in NAV