Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  Buy Now
  HXTT Excel v6.1
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

Insert of pks marked for deletion
Rob Gansevles
2011-03-22 04:04:46.0

One of our customers is running a VFP app and an sql-based app (using your driver) on the same dbf files concurrently.
The VFP app is a legacy app that cannot be changed easily.
The sql-app is Servoy which generates sql in a general way and can only create standard sql.

We are now having an issue when the VFP app inserts a new record and then deletes the record (marks for deletion).
The sql-app creates a new pk by issuing a select-max(pk) on the table.
The insert from the sql-app fails because the select-max does not see the deleted PK, but it also cannot insert the PK (duplicate key conflict).

My question is, is it possible for the driver to handle this?
Could your driver change a insert of a PK of a marked-for-deletion record to an update/undelete of that record?

It is not possible for the Servoy sql generation to handle this because the sql would be very driver-specific.

Thanks in advance.

Re:Insert of pks marked for deletion
HXTT Support
2011-03-22 06:22:23.0
You should use deletesAreVisible=true connection property,

deletesAreVisible: Indicates whether DBF's resultSet includes deleted records.

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap