Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.193
  HXTT Cobol 5.0.193
  HXTT DBF 7.1.194
  Buy Now
  HXTT Excel 6.1.197
  HXTT Json 1.0.165
  HXTT Paradox 7.1.193
  HXTT PDF 2.0.193
  HXTT Text(CSV) 7.1.193
  HXTT Word 1.1.193
  HXTT XML 4.0.194
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)

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


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