Table myTable has N fields: mfield1, mfield2,..., mfieldN
I use VFP6 SPT query
SQLEXEC(lnHandle, "INSERT INTO myTable (mfield1, mfield2,...,mfieldS) VALUES (?lparam1, ?lparam2, ...,?lparamS)")

If all fields are included in the SQLstring it works OK.
However, if not all field are included it does not work.
Why it happens?
Maybe because some fields don't have default value.

TIA

Edward