Further to my previous issue - I've tried the following which demonstrates the problem:
In HXTT Database Admin V0.5 tool, I ran the following query "select * from conf where conf_id = 15" and get no rows returned.
If I run "update conf set id = 1000 where conf_id = 15" I get the message saying
"Has successfully executed! It influenced 15 records!"
Any help appreciated,
Thanks
Nick.
|
|
You should have an index on CONF_ID. HXTT DBF will utilize the index file, and won't check whether it's deleted rows. We will release a package which check whether it's deleted row for indexed column in 24 hours.
|
I downloaded the 3.1.050 version and it now works fine.
Thanks for your quick response.
Nick.
|
Main
webmaster@hxtt.com