>SPT cursors have Record buffering enabled. You can ussue TABLEUPDATE() after APPEND BLANK.
>
>APPEND BLANK
>TABLEUPDATE()
>SELECT * FROM ...
>
>
>>I can SELECT from one, except if I have an empty set, do an APPEND BLANK and then try to Select. I'll try the new setting to see if this does it.
Weird... I never think of it as an actual cursor, because I don't (can't?) use it to update. You're right, a TABLEUPDATE() does it. Doesn't seem like I can set it to buffering = 1, even if I wanted to (i get an error telling me it HAS to be Optimistic).
Anyway, this seems to be the best workaround. Thanks again Sergey!
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".