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