Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi, Charles
If you look at my first post, I believe that I said this was already done. When I look at the string from VFP's debug window, I looks like this.
'"BAR.000000",00,"BAR"'
Thanks.
>Hi,
>
>I think you need to pass your values comma delimited with quotes around each value.
>SQL also wants a double single quote around strings with quotes in them.
>
>Try using STRTRAN to add the double single quote and quotes between commas.
>
>example
>
>stringtxt = "dave,o'brien,23,bar.000"
>insertline = "insert into tmptable values('" + STRTRAN(STRTRAN(stringtxt,"'","''"),",","','") + "')"
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement