General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>Thanks Elmer, I already understood that. I was trying to point out that the SQL SELECT would pick up the deleted records in an uncommited table/cursor.
Yes, but SQL Select will also not get new records that are added but uncommitted when buffering = 5. Try this. With set deleted on, create a cursor, set buffering to 5, do not do tableupdate, select * from that cursor. You should get no records because the 2 records added are buffered and not yet committed. It works the same for deleted records. If you tableupdate the 2 new records, then delete one of them without tableupdate, when you select * you will get both records with neither deleted. However once the buffered deleted record is committed, when you select * you will get only one record.
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