Hi,
Before buying a hxtt paradox server license I'm evaluating the trial version (v3.1) and have noticed the two following problems that are annoying for me.
I'm working with an old paradox 4 database created with Borland BDE 16 bits.
First : the maximum number of rows in a ResultSet is 1000 : is it a limitation of the trial version ?
(Remark : i have noticed that .setMaxRows(int) has no effects even with lesser values)
Second : I've noticed that a randomly number of records are missing in a ResultSet after executing a (simple) query on some tables (select * from table) and without any error message. After investigating it appears that it is due to a secondary index defined in those tables : if I delete the secondary index, the execution is OK. I take your attention on the fact that I DON'T needed to delete ALL secondary indexes from the table, only one. I think it could be a bug.
If I can deal with the second problem, I cannot with the first, so, before buying I need to know if it's due to a limitation in the trial version.
Thanks for responding to my questions
Best regards
|
>First : the maximum number of rows in a ResultSet is 1000 : is it a limitation
> of the trial version ?
Yeah. It's descripted at Introduction of HXTT Paradox Packages
>Second : I've noticed that a randomly number of records are missing in a
> ResultSet after executing a (simple) query on some tables (select * from
> table) and without any error message. After investigating it appears that it
> is due to a secondary index defined in those tables : if I delete the
> secondary index, the execution is OK. I take your attention on the fact that
> I DON'T needed to delete ALL secondary indexes from the table, only one.
> I think it could be a bug.
It's no bug. One of your index contains old row information. You can run once REINDEX {ALL | indexFileName[,...]} ON table_name sql, then your issue will disappear.
|
Main
webmaster@hxtt.com