0

Using the "SQL=" command

Can anyone give me an example of using the "SQL=" command over the Navision SQL database.

I can't seem to get it to connect as it always comes up as #VALUE

An example of what I have tried is:

=NL("Rows","SQL=SELECT ""Item No."",""Location Code"" FROM ""Stockkeeping Unit"" ",{"Item No.","Location Code"},,,,,,,,,,,,,,,,,,,)

I have used just changed an example Northwind query to try and access the Navision Tables.

Regards,

Lloyd

4 comments

Please sign in to leave a comment.