General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
It turns out that this cause me OTHER problems down the road. Many days later, I found out what was causing the bahavior...
I was having strange behavior with a table buffered cursor (created with SQL passthrough). In one case an UPDATE statement issued against the cursor gave me this message:
2072 Cursor cannot be modified because it contains an unsaved record.
Why would a table-buffered cursor need to be saved before you could make a change to a record? Weird.
In the OnSave() of the form, I got other strange errors. TABLEUPDATE, TABLEREVERT, GETFLDSTATE, GETNEXTMODIFIED didn’t work on the cursor at all – unless I SET STEP ON. Yikes. Nothing and I mean nothing but SET STEP ON made it work.
I FINALLY tracked it down. The table was bound to a grid. The Valid() event of one of the textboxes in one of the columns called a method on the form … which changed the value the textbox was bound to…
Apparently, having the textbox bound to the value and then having it call a routine that changes that very same value doesn’t work very well in VFP <s>.
Apparently, this is what causes error 2072, at least some of the time!
Cheers!
Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only