Hi, I'd like to know how base handles transaction regarding the underlying database.
>From some documentation (IDL-ref or dev guide) I know a newly created connection is set to autocommit by default. Does bases connection layer handle it this way? Or is it switched in the database directly? Can I switch a connection to explicit commit without influencing other connections to that database (i.e. on the client side, not the complete db)? For the curios some substantial info: I'm preparing a database application using the internal HSQL. This thingy will run with another backend if it is ready (Postgres, maybe Firebird). For some products in this db there has to be a check on order if the stock count is sufficient to fulfill the order. If not, entries in a table storing order requests have to be made for those parts not in stock in adequate amount. This stock checking is to be run "all or nothing", so if one "insert"-statement fails, the whole thing must be rolled back. This would be implemented perfectly easy using stored procedures, but since it has to be database independant I do with a script in the database currently. TIA, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
