Sql Statements in C/AL – Part 2 : Create View

The following code can be used to create a sql view in a given, external database. // local variables ADOConnection Automation ‘Microsoft ActiveX Data Objects 2.8 Library’.Connection ADOCommand Automation ‘Microsoft ActiveX Data Objects 2.8 Library’.Command ADORecSet Automation ‘Microsoft ActiveX Data Objects 2.8 Library’.Recordset connString Text 1024 activeConnection Variant viewName Text 100 // the code //… Continue reading Sql Statements in C/AL – Part 2 : Create View

Sql Statements in C/AL – Part 1 : Select

There is no possibility to read data from an external database with standard c/al. Best way to do that till NAV version 2009 is using ADO. With Nav vs. 2013 upwards you can use .Net classes. The following code can be used to read data from a given, external database. // local variables ADOConnection Automation… Continue reading Sql Statements in C/AL – Part 1 : Select