General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi David,
>
>You may consider using XML. VFP9 OLE DB provider supports XMLTOCURSOR() and >CURSORTOXML() functions whick makes it easier to use XML.
Thank you Sergey, that seems to be a very sound suggestion. I am seeing something like this : before a stored procedure gets called, I check whether the database is VFP and there are more than 26 parameters, and only in this case, call a custom function which transforms my parameter list into just one parameter containing XML text (then some work is to be done on the database side as well). Of what type should this one parameter be ? adLongVarChar ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only