Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  Buy Now
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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 Xin Tian Tai Ltd. of Beijing City (abbr, HXTT)

HXTT Paradox
Paradox Table suddenly empty
2009-11-08 10:32:58.0

I have a problem witch hxtt paradox. When I use your driver with my code which select all data from a paradox table, check the data and delete the actually record if the record has the right shipmnt number for the first time it works. When I start my code again the table is empty for my application. I also checked the table wir RazorSQL based on your driver. The table is also empy. When I check the table with classical BDE and Borland dbExplorer the table is full whith data. I don't know what to do.

I think it's my code which block or something like that the table for you driver: My code looks like this:
String url = "jdbc:Paradox:////" + args[0];

Connection conPrime = DriverManager.getConnection(url,"","");
Connection conSecond = DriverManager.getConnection(url,"","");

Statement stmtPrime = conPrime.createStatement();
Statement stmtSecond = conSecond.createStatement();

ResultSet rs = stmtPrime.executeQuery("SELECT * FROM dbObjects");

if(rs.getInt("ShipmntNo") < 9900){
//Do something with the data
//than delete this record
stmtSecond.executeUpdate("DELETE FROM dbObjects WHERE ShipmntNo = '" + rs.getInt("ShipmntNo") + "'");

I suggest the problem is at the part where I make a second connection and delete the current record. But why it works for the first time and the next times it doesn't work? When I restore my table from my buckup it works again for the first time.

Has anyone an idea?
Re:Paradox Table suddenly empty
HXTT Support
2009-11-08 17:14:22.0
Please send use your db sample so that we ca recur your issue.
Re:Re:Paradox Table suddenly empty
2009-11-09 02:11:48.0
And how, I can't attach any files here.
Re:Re:Re:Paradox Table suddenly empty
HXTT Support
2009-11-10 05:26:18.0
You can send email to webmaster or support @ .

Search Key   Search by Last 50 Questions


Copyright © 1999-2017 Heng Xin Tian Tai Ltd. of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap