Hello,
Can Navision refer to sql table?
I have two tables in the same sql server 2005 database: tableNav created in Navision Object Designer and tableSql created by Sql server tools.
It is possible to get data form tableNav and set it to tableSql using Navision tools? :-k
0
Answers
RIS Plus, LLC
Example
http://www.mibuso.com/forum/viewtopic.php?t=9995&highlight=
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
That was my idea but this (SET @param = Country.Code) doesn't work.
Do you have any suggestion how to do this task (export data from Nav table to sql table via ADO)?
Here is some code:
http://www.freevbcode.com/ShowCode.asp?ID=3687
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
I created Ado parameter, but now I have problem with sql statement. That's my code
end error "Must declare the scalar variable "@var".
What should I pass as value in insert into statement?
and call your SP. Something like:
in your stored procedure, you could put your INSERT statement.
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
This code works: I forgot about