You could also use SQLEXEC() to send a SQL UPDATE command to SQL Server. Make sure the following are set on the update criteria tab in the view designer:

1. Your view is marked to Send SQL updates.
2. One or more key fields are marked in the view and the field(s) represent a unique value for each record.
3. The fields you want to add to the table (including the primary key if it's not auto-incrementing) are all marked for update.

If you've done all this, see if TABLEUPDATE() returns .F. after you add a new record. If so, use AERROR() to determine the error returned. That may help track down the problem.

>No, I want to add records using REMOTE VIEWS. What other way is there?
>
>
>>Just to be sure I know what you want, do you want to add records WITHOUT using remote views?
>>
>>>I have been able to UPDATE my records but I can't ADD a new one.
>>>Since I am new with ODBC I have created a form with a remote view
>>>and then I am using the Wizard buttons to do the rest.
>>>
>>>Can you send me some sample code about Adding, deleting, updating,
>>>etc through ODBC?
>>>
>>>Thank you again
>>>
>>>
>>>
>>>>We use VFP to add data to SQL Server tables all the time. What's the specific problem?
>>>>
>>>>>Is there a limitation about adding records from Visual FoxPro?
>>>>>
>>>>>I can't add a new record to Access or SQL tables.
>>>>>
>>>>>Any suggestions or comments will be welcome
>>>>>
>>>>>Thank you in advance.