So, I try to retrieve data from list coming from SQL database, that is to say, users have to look for data in a list on a form (like a lookup table) but values are saved on a table in SQL database.
So first, i create a codeunit with a ADO connection to database, but i don't know how to fill in dynamically a list in navision from SQL. :-s
I think you'll need a codeunit that retrieves the database from the external database, populates a temporary record buffer with it, and displays that record in a form that's used as the lookup form. Is that what you mean?
Comments
Jan Hoek
Product Developer
Mprise Products B.V.
So, I try to retrieve data from list coming from SQL database, that is to say, users have to look for data in a list on a form (like a lookup table) but values are saved on a table in SQL database.
So first, i create a codeunit with a ADO connection to database, but i don't know how to fill in dynamically a list in navision from SQL. :-s
Jan Hoek
Product Developer
Mprise Products B.V.
Thanks!