Tables and Stored Procedures

[celfyn]

Hello,

Is it possible to fill an Ebase table with the contents of a stored procedure resource, or do I have to use a table resource?

Thank you.

[Hovik]

Unfortunately Ebase stored procedures don't support result sets at the moment. However there is a solution:

• 1. Use a database resource marked for use with tables.
  2. Put your stored procedure call in the select section under Advanced SQL using field substitution to supply parameter values if required - e.g. exec proc_name search_string = &&search.
  3. Call fetchtable from your form on a table that is mapped to the table DB resource.