Can someone help me with the following tableupdate issue. (We are using VFP 7, SP1 on Windows 2000, SP2).
Background:
To add a new record to table "Patient" our application uses a buffered view, "PatientView". On saving we issue a tableupdate() inside a transaction. This has worked correctly.
Yesterday I added a second instance of table "Patient", opening it
... in 0 again alias "PatientPick" noupdate
This is to permit its use in an incremental search without disturbing the original Patient.dbf.
Problem:
Now if "PatientPick" is open, tableupdate of "PatientView" consistantly fails with the less than specific error message, "Cannot update the cursor". If, however, "PatientPick" has first been closed, the tableupdate succeeds.
This is unexpected (to me). Is this behavior "by design"? Any assistance would be greatly appreciated. Thanks!
Spence