Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert FRom VFP to SQL
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00127638
Message ID:
00127844
Views:
34
>This code Works Fine as Long as there is no Single Quotation Marks in any Field ie '
>
>Does any body have a solution of how to solve this problem. I cannot get rid of any quotation marks in the fields. There are authors names Like O'Donnel etc

You need to replace any single quotes with two single quotes:
 lcText = STRTRAN(lcText,"'","''")
+++ Rick ---
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform