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.
Tables and Stored Procedures
Moderators: Jon, Steve, Ian, Dave
-
- Ebase User
- Posts: 2
- Joined: Tue Jun 29, 2010 3:09 pm
- Location: Wales, UK
-
- Moderator
- Posts: 184
- Joined: Tue Sep 11, 2007 8:58 am
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.
0 x
Who is online
Users browsing this forum: No registered users and 43 guests