I've come across a little glitch in some code that has stumped me. Maybe someone out there can give me some idea on how to resolve.
I have a remote view that is tied to a sql server backend table. It is a remote view to one table only. No muli tables are being used.
In code, I am deleting data in a memo field for a record and then setting up a transaction save to sql server. Upon issuing a tableupdate(2,.t.,alias(),aSaveError), I get a return of .t. that the update ocurred and that no errors were logged to the error array.
When you browse the sql server data, the changes were not made. When you browse the view following the tableupdate, the record that was modified is no longer there. But yet it exists on the sqlserver data with the old data.
Any ideas on what could be going wrong? BTW, this is in VFP 5.0a. The client is not able to move to 6.0 at this time.
Pat.
Patrick L. Stovall
Senior Architect/Developer
MCP - C#
VeroQuest
P.O.Box 7216
Kalispell, MT 59904