I have been trying out the trial version of FSQL for a few days now trying to solve a specific task I have.
I need to get order data from MSSQL database to Allen Bradley CLX.
I’m currently using a RSview/VBA application to call my stored procedures and then push each value to string/integer objects on a display and then download. What i’m looking for is a way to replace that RSview/VBA solution with a more transparant and “easy-to-change” solution.
I think the biggest issue is that the database and stored procedures are “locked” as a standard now and it would take some heavy arguments to make changes there. And the major stored procedure which is called every 10 sec. to check for new released order returns 5 recordsets each returning different amounts of rows.
Does anyone have experience with FSQL and stored procedures returning multiple recordsets?