>Using SQL Server 7.0 as the back-end, I have a remote view for product table where all fields are displayed and updateable. When the view is set to 3 or 5-buffermodeoverride and then issued tableupdate after inserting a record it fails because when I close the form and open it again, records inserted are gone. I tried setting buffermodeoverride to 1, insert a record and it succeed. What's happeining here guys? I reviewed the settings of the view i.e. update criteria, update all, sql update etc. but to no avail.
What does TABLEUPDATE return? Have you checked the contents of AERROR()?
Erik Moore
Clientelligence