CAL code to SQL Query

Comments

• Marije_Brummel Member, Moderators Design Patterns Posts: 4,262

  2010-03-08

  There is a dll file that handles the conversion.
  
  More info: http://dynamicsuser.net/blogs/waldo/arc ... n-sql.aspx

  Marije Brummel | Freelance Business Central Specialist

  0
• matttrax Member Posts: 2,309

  2010-03-08

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

  Matt Traxinger - ArcherPoint

  0
• kine Member Posts: 12,562

  2010-03-08

  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...

  Kamil Sacek
  MVP - Dynamics NAV
  My BLOG
  NAVERTICA a.s.

  0
• David_Singleton Member Posts: 5,479

  2010-03-08

  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

  David Singleton
  

  0