Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT INTO cannot be parameterized?
Message
De
16/09/2003 23:10:46
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00829582
Message ID:
00829719
Vues:
24
>However, I want to give the same expression to SQLEXEC()... won't that need the "?"s?
>
>lnID = 5
>lcDate = {^ 2003/06/01}
>lcName = [Johny "Shortie" Smith's kid, ]+"[25 yrs old]"
>SQLEXEC( nConnHnd, "INSERT INTO MyTable ( TableID, Name ) VALUES ( ?lnID, ?lcName, ?lcDate )" )
>
>The parameterization should handle encoding so that string concatination can be avoided.


You can't pass three values to two fields!

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform