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
|
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.
|
Thanks for the update, I'll try it out. Could you also tell me why the blank rows are introduced at all?
Thanks,
Frank
|
Thanks for the update, I'll try it out. Could you also tell me why the blank rows are introduced at all?
Thanks,
Frank
|
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.
|