Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass-through character limits?
Message
From
07/12/1998 11:44:40
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00164772
Message ID:
00164811
Views:
17
Hi Don ---

>If the limit is 255, would it then be possible to create a stored procedure on the back-end via odbc and pass a series of strings to build the procedure and then execute it for the proper results?

Yes. You can then run the stored procedure with SQLEXEC() and return a result cursor from the same: Here's an example:

cState="FL"
=SQLEXEC(nConnectionHandle,'sp_getstates "'+cState+'"',mycursor)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform