frank | 2006-09-07 16:27:53.0 | |
Hi,
I recently bought the HXTT Text(CSV) driver and have the following issue: I have a very simple table called "numbers.csv": NUM 1 2 3 4 When I delete records with the following statement: delete from numbers where num > 2 then blank lines are intoduced in the text file. Why is that? When I try to remove the rows myself with: delete from numbers where deleted() I get a timeout. Can you help me out please. Frank Montyne | ||
HXTT Support | 2006-09-07 18:56:02.0 | |
Thanks for your response. Please download the latest package now. I have tested with the following sqls:
delete from numbers where num > 2 ; delete from numbers where deleted() ; select * from numbers; BTW, "pack table numbers;" is preferable to pack empty rows. If you still meet timeout exception, you should check whether an open ResultSet object is holding that table, because pack table will use table exclusively. | ||
frank | 2006-09-08 00:10:09.0 | |
Thanks for the update, I'll try it out. Could you also tell me why the blank rows are introduced at all?
Thanks, Frank | ||
frank | 2006-09-08 00:10:38.0 | |
Thanks for the update, I'll try it out. Could you also tell me why the blank rows are introduced at all?
Thanks, Frank | ||
HXTT Support | 2006-09-08 02:05:54.0 | |
It's possibly produced by insert/update/delete sql. You can use ResultSet.rowDeleted() to find those blank rows. A pack table operations will remove all blank rows. |