>>>I have set test client server app that requires the usual add,edit, delete functions. The edit's work grate using buffering and tableupdate(). When adding a record the the remote view it does not want to add the the SQL Server Database after issueing a tableupdate(). What am I missing to make this happen ?
>>>
>>>Thanks
>>>
>>>Scott
>>Hi Scott!
>>Did you try to get result of TableUpdate() and then analize what was wrong?
>>Try something like this.
>>lcResult = TableUpdate() && Select parameters of tableupdate according your situation.
>>IF lcResult = .F. && Can not commit changes.
>>= AERROR(aErr)
>>SET STEP ON
>>* In debug mode watch what is wrong.
>>ENDIF
>>Marat.
>The array returned with one .f. element. Some additional info : I have opt. table buffering. I have two records in a grid one was changed and one was added. The changed record updates no problem. The added record will not add on the SQL Server. The delete will also delete no problem.
>
>Thanks
>
>Scott
Do you have Buffering 5, it seems to me that you have 3, that is why it changes only one record.
Marat.