Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  Buy Now
  HXTT Excel v4.2
  HXTT Paradox v5.2
  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
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Accessing tables in VFP DBC
Paul Hall
2007-12-09 05:54:09.0
I have tables in a Visual FoxPro DBC. I've tried the approach described in question 4 from the FAQ for accessing these tables. The tables that are in the same directory as the DBC are accessible.

However, Tables in a DBC do not have to be stored in the same folder as the DBC itself. And, in this case we specifically have to store the different tables in different folders. How can we access the table through the DBC without having to reference each individual folder. (If we have to put the folder where each table is stored, this means we're just ignoring the DBC and treating the path to the table as if it were a free table in the same folder as the DBC).

I'm must be doing something wrong. Thanks for your help.

(e.g. Select selldate,sellname,sellqty from MyDBC.MyTable3,
where MyTable3 is stored in Folder3, instead of in the same folder as the DBC.)

Thanks, Paul Hall

Re:Accessing tables in VFP DBC
HXTT Support
2007-12-09 06:43:07.0
>Select selldate,sellname,sellqty from MyDBC.MyTable3,
>where MyTable3 is stored in Folder3, instead of in the same folder as the DBC.
You can remove MyDBC, and change the jdbc url, use Select selldate,sellname,sellqty from "Folder3".MyTable3. MyDBC isn't necessary for accessing DBC's tables.
Re:Re:Accessing tables in VFP DBC
Paul Hall
2007-12-09 14:09:50.0
So, this seems to access the table directly on its path, not using the DBC.
For each query, the path to the table has to be included?

Since the DBC already knows where the table is, I was hoping I could put the path to the DBC in the jdbc URL and it would find the table using information in the DBC.

Thanks for your response.

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap