안녕하십니까..
Zeos및 파이어 버드로 DB Program 을 짜고 있는데 Insert 명령을 2줄을 넣으면
Error가 발생 합니다
Insert 명령을 1줄을 사용하면 괜찮음
여러줄 입력을 할수 없는것인가요?
그리고 ZeosComponet인 ZConnection의 속성중 TransactIsolationLevel 의 값들이 어떻게 동작하는지
알려 주시면 감사하겠습니다.
(tiNone, tiReadCommitted, tiReadUncommitted, tiRepeatableRead, tiSerializable)
-> 보통 Db Program을 짜면 어떤 속성을 주고 사용하는게 좋은지요?
//////////////////////////////////
Error 남
/////////////////////////////////
ZConnection1.StartTransaction;
ZQuery1.Close;
ZQuery1.SQL.Clear;
ZQuery1.SQL.Add('INSERT INTO History_Eeprom (BAR_CODE, COPY_DATE) VALUES(:No, CURRENT_TIMESTAMP) ');
ZQuery1.SQL.Add('INSERT INTO History_Eeprom (BAR_CODE, COPY_DATE) VALUES(:No2, CURRENT_TIMESTAMP) ');
ZQuery1.ParamByName('No').AsString := edNo.Text;
ZQuery1.ParamByName('No2').AsString := edNo2.Text;
try
ZQuery1.ExecSQL;
ZConnection1.Commit;
except
ZConnection1.Rollback;
end;
//////////////////////////////////
2번 입력하면 괜찮음
////////////////////////////////
ZConnection1.StartTransaction;
ZQuery1.Close;
ZQuery1.SQL.Clear;
ZQuery1.SQL.Add('INSERT INTO History_Eeprom (BAR_CODE, COPY_DATE) VALUES(:No, CURRENT_TIMESTAMP) ');
ZQuery1.ParamByName('No').AsString := edNo.Text;
try
ZQuery1.ExecSQL;
ZConnection1.Commit;
except
ZConnection1.Rollback;
end;
ZConnection1.StartTransaction;
ZQuery1.Close;
ZQuery1.SQL.Clear;
ZQuery1.SQL.Add('INSERT INTO History_Eeprom (BAR_CODE, COPY_DATE) VALUES(:No2, CURRENT_TIMESTAMP) ');
ZQuery1.ParamByName('No2').AsString := edNo2.Text;
try
ZQuery1.ExecSQL;
ZConnection1.Commit;
except
ZConnection1.Rollback;
end;
|