| View previous topic :: View next topic |
| Author |
Message |
celfyn
Ebase User
Joined: 29 Jun 2010
Posts: 2
Location: Wales, UK
|
 Posted: Tue Jul 20, 2010 12:06 pm Post subject: Tables and Stored Procedures |
 |
|
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. |
|
| Back to top |
|
 |
Hovik
Moderator
Joined: 11 Sep 2007
Posts: 30
|
| Posted: Mon Aug 23, 2010 2:05 pm Post subject: |
|
|
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. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
