How to Call a Stored Procedure from Navision

kamel.hedi

I want to call a Stored Procedure (SP) from navision (in C/AL Code) ????

This SP is written to retrieve data from tables on Navision (SQL Database) and update the corresponding fields in another SQL DB.

Can someone help me? Sytax of the call, where should I place parameters on the call ? and how can I retrieve (read) the output of the SP.

Thanks

Wiechardt

Search this site for "Stored Procedure" and you will get wonderful results, such as: http://www.mibuso.com/forum/viewtopic.p ... +procedure

Regards
Wiechardt