Steve
|
| Posted: 09/19/2002, 1:59 PM |
|
Hi Guys,
I want to use an SP to return data used in an object generated by the record builder. I can generate the call to the sp easily enough, but have no idea how to tell the various fields where they get their values from.
As usual, a lengthy read of the documentation has proved fruitless!
TIA Steve
|
|
|
 |
eDuck
|
| Posted: 09/19/2002, 3:21 PM |
|
Once you have a valid Stored Procedure, all you need to do is change your source table for the form to Procedure, instead of table. This will then pick up the fields from the stored procedure, exactly as would if you connected directly to the table.
There is one catch however in CCS as far as SQL (MS-SQL I suppose). When you enter the SQL SP, it will look for any INPUT or OUTPUT values that the SP requires, and in addition, it will also have a value for @RETURN_VALUE. If you do something with this value, then keep it, otherwise, simply delete it from the param list.
|
|
|
|
|
