>Good afternoon the whole ones
>Is there some way to insert only the data that I want in a table and not everybody?
>For example:
>suppose that my table has three fields, to the invéz of me to do that:
>
>result = SQLPREPARE(handle, ' Insert Into Clientes Values (?mvar1?mvar2?mvar3) ')
>=SQLEXEC(handle)
>
>I would like to do like this:
>
>result = SQLPREPARE(handle, ' Insert Into Clientes(var2) Values (?mvar2) ')
>=SQLEXEC(handle)
>
>and to insert only in the field 2, but does FOX come back me a mistake and doesn't it record anything, is there some way to do that?, and the one what is been there I am doing wrong?
>
>Thank you very much for the help of everybody.

There might be a few reasons for the error:
- One, depending on the backend you might need a space in between Clientes and the list of fields to update (or is that a typo?)
- Two, maybe one or more of the other fields do not accept nulls or empty values, thus the error.
- Three, maybe the value in mvar2 is not acceptable in field var2.

What is the error message you get? Check the results of an AERROR() call to get a few more details on it.