No uso Interbase pero deberia ser algo asi .
Código SQL
[-]
SET SUTOCOMMIT TO FALSE; ?????
SET TRANSACTION;
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('1',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('2',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('3',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('4',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('5',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('6',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('7',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('8',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('9',1,1)
INSERT INTO LOCK(ROOMNAME,ROOMTYPEID,HARDWAREID) VALUES('10 ',1,1)
COMMIT;