Can not get Stored Procedure to Run

BLOMASKY

I wrote a very simple test SP to select 3 columns from a table. It runs fine (in SQL Server), I created a BO with 3 columns and have a rule form on the query with:

EXEC_SP 'TestSP' RETURN TestSPData

When I run the query, nothing is displayed. What am I doing wrong?

Thanks

Bruce

BobK

Bruce,

Is TestSPData the table that your SP selects the 3 columns from? I believe it needs to be.

Not sure if it matters, but all of my SP return all columns from the table.

BLOMASKY

BobK wrote
Bruce,

Is TestSPData the table that your SP selects the 3 columns from? I believe it needs to be.

Not sure if it matters, but all of my SP return all columns from the table.

I can do that, but reading the manual, it seemed like I should have a diff. BO for the result set. I will try it your way and see if that works.

Thanks

Bruce

crisg0112

BLOMASKY wrote
I wrote a very simple test SP to select 3 columns from a table. It runs fine (in SQL Server), I created a BO with 3 columns and have a rule form on the query with:

EXEC_SP 'TestSP' RETURN TestSPData

When I run the query, nothing is displayed. What am I doing wrong?

Thanks

Bruce

Bruce,

the way stored procedures are implemented in aware is not the 'native' stored procedure in SQL wherein the result / result sets can be in memory only. it will need a BO.

BLOMASKY

Chris, I am attaching the EXEC_SP to a query for a BO. I still don't get any results. There must be something I am missing.

thanks
bruce