Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  Buy Now
  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)

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

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
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
And how, I can't attach any files here.
Re:Re:Re:Paradox Table suddenly empty
HXTT Support
2009-11-10 05:26:18
You can send email to webmaster or support @ .

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