Hi, I have lost some insert in DBF tables without autoincremet. How do I check if the insert was performed successfully? Should I do Select to verify?
Thanks
|
>I have lost some insert in DBF tables without autoincremet.
If you're using concurrent insert with multi applications, you should use lockType=VFP (or other value) connection property.
If you're using transacotion mode, you should use Connection.commit to submit your inserted data, otherwise, it'll be rollback.
Anytime, __rowid__ can be used to get the record number, and reccount() function can return the total record count of that table.
|
Thank you for the quick response.
I use Harbour simultaneously with Java 1.8 HXTT Driver.
The connection url is
if (System.getProperty("server").equals("ba")) {
url = "jdbc:dbf:////system/dbfg/?lockType=Harbour"; // Place
} else {
url = "jdbc:dbf:////dbfg_bahia/?lockType=Harbour"; // remote NFS
}
lockType=Harbour is correct?
Thank
|
If your application is xHarbour, you can use lockType=VFP. You should check your index file suffix. You should use lockType=CLIPPER if you found *.ntx index files.
|
Main
webmaster@hxtt.com