Execute SQL -SQL Stored Procedure

[NewFM85User]

I am very new to FM, I am using FM 8.5 advanced

I need to integrate SQL Server and FM. I did some research and found out that It is possible to execute SQL stored procedures from FM . My question is how to handle outpouts from stored procedures, if my stored procedure is returning values or recordset , how do I populate in FM ?

It would really help and avoid duplicate coding if I call the same stored procedure from SQL server.

Thanks

[hlabonte]

You do it with an import step. Import records, from ODBC source and call your SQL there.

[NewFM85User]

Thanks...

I also tried it with Import Records script and in the query give the Stored proc name enclosed in double quotes, when u go to bind the variables, it will show any values returned from Srored proc.

Thanks again.