Pat,

After your tableupdate() returns false, call aerror(myError) and look at element two of myError[2] which will give you the error message from the server. Most likley you are either violating some consrraint or trying to insert a null into a column that doesn't allow that.

BOb


>I have a remote view and I can successfully make updates to existing records (which I created in SQL Server). However, when I append a record to the view (append blank), fill in some data, and then call TableUpdate, the return code is .f. I have a grid on my test form which displays the records in the view and the new record is added in the grid (which I assume is the local copy of the view) but it is not added in the remote view.
>
>Is there something else which must be done to append a record?
>
>Thanks for any assistance you can provide,
>Pat