Hello, my problem as follows: I have to transfer datas from my navision-database into a sql-database. In the sql-db are some rules to stick to. Therefore I placed “stored procedures” in the sql-db. Now I like to execute these “stored procedures” from my navision-db (V. 3.10) What I already have is: - I got contact between Navision (over “automation - datatype” and the “Microsoft SQLDMO Object Library”) and the sql-server. - I can select the database and see the stored procedures" What I hope to get from you is: How can i - deliver the parameters to the “stored procedures” - proceed the “stored procedures” - interpretations of the value of the “stored procedures” Who can help? Tx a lot Regards Falko Risch
Hi Arhontis, thx for your quick answer. You solved two of my three problems.[:)] Now i have only one problem: Where can i deliver (or set) the parameters for the stored procedure? Regards Falko
I haven’t done this before, no time You could also look at: http://www.mibuso.com/forum/viewtopic.php?t=2609 http://www.mibuso.com/forum/viewtopic.php?t=2911 that mentions alot about stored procs… Regards, Arhontis