Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert FRom VFP to SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00127638
Message ID:
00127844
Vues:
39
>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform