Information générale
Catégorie:
Codage, syntaxe et commandes
I'm trying to formulate a design for data classes that accept SQL statements and either execute them locally or send them through SQLEXEC to a back end data store.
I want the SQL to be as similar as possible, yet I was startled to find that while VFP handles ?parameters fine locally for SELECT, it fails for INSERT.
After fixing my table name, I found that ?Parameters DO work fine over SQLEXEC for the INSERT statement.
>Yes, you'll need parameters for SQLEXEC but what it has to do with VFP native code?
>
>>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 )" )
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