>>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!
No it is not. No need to tableupdate to select from. Tableupdate would send the updates with an updatable SPT.
Cetin