Re: Turning of logging and updating rows?

Basically, you just run the UPDATE statement as normal. Don't use BEGIN or COMMIT, as they're not supported. In a non-logged database, you need to understand that if an update fails in the middle, any updates that were made are permanent; it will not roll back a failed update statement, because there are no logs to roll back _from_. Using non-logged databases is usually a bad idea, except when doing large initial loads or something. dickey wrote in message <36491a26.487901449@news.mindspring.com>... >All, > > What is the procedure for updating rows in a database with >logging turned off? Without the use of a begin and commit, how is >this done? > > > Thanks for any insights >