Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedures and the 26 parameters limit
Message
From
15/02/2005 11:28:57
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00976697
Message ID:
00987081
Views:
53
I just wanted to come back at this one, and say that after a lot of surprises and of hard work, the XML solution WORKED ! Thank you again for your suggestion.
For the moment I opted for the suboptimal solution of using CURSORTOXML() after creating a lot of cursors, depending of the type and size of the parameters. Then the call to a VFP stored procedure is replaced by a call to a special stored procedure, which takes as parameters the XML strings and the name of the stored procedure. Each stored procedure has dictionary entries stating its parameters names, hence the parameters passed through XML can be matched. This allows both to work around the 26 parameters limit and to pass parameters by name instead of by position.
Still to do are :
- Finishing the code parser which will analyze the stored procedure code found in the data dictionary to fill user dictionary tables with the procedure names and parameters.
- Improving the performance.
- Understanding how to have XMLTOCURSOR() correctly restore texts with carriage returns in them. Any idea ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform