Opening a table without opening Database

[AlanArons]

Is it possible to get the data from a table contained within a database without opening the database.

I am working with an app that has its own database. I would like to access data in another db but dont want have to close the current db and then reopen all the files after I get what I want.

Any ideas?

Alan Arons

 

[TamarGranor]

VFP doesn't limit you to a single open database, so just go ahead and get what you need. The data you already have open will stay open.

Tamar

 

[JRB-Bldr]

If you are using data tables from multiple VFP databases concurrently, remember to USE a table set the specific database to the the table's 'container'.

OPEN DATABASE DBC1
OPEN DATABASE DBC2

SET DATABASE TO "DBC1"
USE DBC1Table IN 0

SET DATABASE TO "DBC2"
USE DBC2Table IN 0

OR
Specify the database which contains the table within your USE command.

OPEN DATABASE DBC1
OPEN DATABASE DBC2

USE DBC1!DBC1Table IN 0
USE DBC2!DBC2Table IN 0

SELECT DBC1Table
<Do Whatever>

SELECT DBC2Table
<Do Whatever>

Good Luck,
JRB-Bldr

 

[AlanArons]

Thanks guys

This is exactly what I was hoping for.

Alan