>How about using Begin Transaction and End Transaction??
>
>Does it Force update on Table other than Table Buffering Control??
Justok,
Transaction onnly work for tables that are in a dbc. Free tables cannot be handled with transations.
Using transactions is ti a very good idea to keep the BEGIN and END/ROLLBACK as physically close to each other in the code as is possible. This shortens the amoutn of time that resources are locked in the system. The only way to get a transaction to work for an unbuffered table would be to wrap the entire data processing code inside of the transaction. Buffering allows you to do all of the data processing first, whne that is done you begin the trnasaction adn do the tableupdates. This brings the begin and end of the transaction as close together as they can get.