A liitle addon. This is what I get in HSqldb properties file after removing user object from job.
SET AUTOCOMMIT FALSE DELETE FROM DC_JOBS WHERE JOB=1 INSERT INTO DC_JOBS VALUES(1,'Administrator') DELETE FROM DC_USERS_JOBS WHERE USERNAME='mikeai' AND JOB=1 DELETE FROM DC_USERS WHERE USERNAME='mikeai' COMMIT I want to only this statement be executed in that case. DELETE FROM DC_USERS_JOBS WHERE USERNAME='mikeai' AND JOB=1 -- Best regards, Mickey [EMAIL PROTECTED], [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
