Automation with Navision 2.6

mbrown

Does anyone have experience working with automation in Navision. Specifically, I am trying to execute an SQL Server stored procedure using the 'command' object of the Microsoft ActiveX Data Objects Library. According to the C/AL symbol menu, this takes a string for an argument, according to VB it takes a connection object. However neither work because when I try to compile, the compiler tells me I need an INTEGER! Any help would be appreciated.... Thanks.

wonmo

The integer values it is looking for are ENUM parameters. You can look these up through the help section of either vb or vba.

mbrown

Thanks Wonmo but I disagree. I believe it's looking for the connection ID which (in VB) comes from the connection object.