You have to check Tableupdate() return value. It will return .F. if it fails. You can use AERROR() to get error info.
>
>I am having trouble with a remote view to an SQL database. My view selects a single record based on UPC in the dbo.Products table.
>
>I have set the view to Send SQL Updates, Update using SQL Update, and selecting all the fields for update. Interactively, when I edit a field or 2 and call a
>Tableupdate(2,.t.) the table is updated successfully. Programatically, it is not updated.
>
>In the code, I have done a
>Set Multilocks on
>Cursorsetprop("buffering",5,"webunit")
>
>I have done similar things in other views and they have worked. What am I doing wrong here? Any ideas? Thanks in advance
>
>Al
--sb--