Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Key in apostrophe
Message
 
 
À
16/09/2004 01:39:44
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00942689
Message ID:
00942893
Vues:
20
This message has been marked as the solution to the initial question of the thread.
lcsqlstringa = STRTRAN(remoteview.field , ['], [''])
lcsqlstringb = [insert into table (field) values ('] + lcsqlstringa + [')]
>I use the sqlexec as follow:-
>lcsqlstringa = remoteview.field (where this is a character field)
>lcsqlstringb = "insert into table (field) values "+lcsqlstringa
>then sqlexec(connectionhandle, lcsqlstringb)
>So now, I should change this into :-
>lcsqlstringb = "insert into table (field) values "+[lcsqlstringa] ?
>Is that correct?
>Yau
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform