Information générale
Catégorie:
Codage, syntaxe et commandes
I am trying to use the following SQL pass-through command:
=SQLEXEC(ln_connection, "INSERT INTO sohshp (&lc_hfields) VALUES (&lc_hvalues)")
I have a valid SQL connection handle, I have defined the fields and values strings and the values are populated with a SCATTER from the VFP table. However, it seems that if the lc_hvalues character string gets over 128 the command failes.
Does anyone know if there is a lenght limit for the INSERT-SQL fields or values clauses?
Will the INSERT-SQL work better with an array or will it work with an object name?
Thanks
Suivant
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