Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough and string delimiters
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00054934
Message ID:
00055438
Views:
24
>>Use the square brackets [ ] to avoid this situation...
>
>That solves the VFP end of things but not the SQL end of it...
>
>Even if it didn't you still have the possibility of an embedded ] in binary data.
>I don't see a way to send binary data which could contain *any* kind of delimiter
>combination you may throw at it.
>
>+++ Rick ---

Big overhead, but you can check if the delemiter is in the string before the sending and use the apropriate delimiter.

Also if all delimiters are include in the string, try breaking it in smaller parts with the right delimiters and send it with '+' between each part.

Yes, big overhead...


:0)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform