HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

Insert a record and the index is not being updated automatically	Pablo Sortino	2009-03-07 13:45:54
Hi, We recently purchased the HXTT DBF 4.0 driver When inserting a row to the database the associate table index is not being updated automatically.. so it basically gets out of sync. If we run a reindex then its all updated fine but I can't make a reindex after each insert. NOTE: If i make a "SELECT" but without use the columns of the index I do retrieve the record recently added (without executes the reindex). NOTE 2: I'm using "Visual Fox Pro Version 5 and 6" Is there something about the connection I need to add specifically for this to work? Cheers, Pablo.
Re:Insert a record and the index is not being updated automatically	HXTT Support	2009-03-08 22:48:52
>When inserting a row to the database the associate table index is not being > updated automatically.. so it basically gets out of sync. Maybe you're using an older package. v4.2.013 fixed a bug on CDX compound format index file, which will sometimes set wrong index node information for specific complicated string index expression on insert operation. v4.2.039 solved a CDX multiuser compatibility issue with VFP, which VFP will produce specific duplicated index information sometimes on mulituser mode.
Re:Re:Insert a record and the index is not being updated automatically	Pablo Sortino	2009-03-09 20:12:55
Hi, thanks for your reply, I downloaded and tried the latest package but still doesnt works. Could you give me an address to upload my tables, to be tested by you. Thanks in advance. Pablo.
Re:Re:Re:Insert a record and the index is not being updated automatically	HXTT Support	2009-03-09 20:38:08
You can zip and email it if it's not very big, for instance, smaller than 5MB. If your file is too large, you can zip and upload your database sample into: ftp site: ftp.hxtt.com ftp user: anonymous@hxtt.com ftp password: (empty) login mode: normal (not anonymous) ftp port:21 upload directory: incoming transer mode: binary (not ASCII) After upload, you can't see that upload file, but it has been upload.
Re:Re:Re:Re:Insert a record and the index is not being updated automatically	Pablo Sortino	2009-03-11 15:09:02
I just tested with the latest package (release date 2009-03-09) and still doesn't work. I sent you the tables and indexes some days ago. Did you have a chance to check them. Thanks a lot. Pablo.
Re:Re:Re:Re:Re:Insert a record and the index is not being updated automatically	HXTT Support	2009-03-11 23:00:34
v4.2.052 fixed an insert bug on CDX index since v4.2.039. Thanks for your response.
Re:Re:Re:Re:Re:Re:Insert a record and the index is not being updated automatically	Pablo Sortino	2009-03-14 13:40:31
The latest driver version (V4.2.052) is working just fine :) Thank you. Pablo.

Email:

webmaster@hxtt.com