Recent content by tcot

How would you set it at run time?

Marco, This system has thousands of updates and inserts (along with deletes!) If I was to open all programs(screen code) I could still be doing this in September! Is there anything else I can do?

Again...... all queries have been closed, when does the actual "post" happen? HELP!!!!

Since I've sent this message, it seems the commit did NOT fix the locking issue! Any ideas why the table is locked until the user closes the program? The user must close the whole Delphi program.... not just the 1 screen!

sql.add('insert into PSIRA.LAB_DETAIL '); sql.add('(SAMPLE_NBR, PROPERTY ) values '); sql.add('('''+sampNbr+''',''Visual'') '); query1.Execute ; end; // if not EOF end; // with Query1 // Add commit code here with query1 do begin close...