Accessing multiple DB's

Todd Cary

Delphi Developer

Sun, 30 Nov 2003 22:53:09 GMT

Accessing multiple DB's

The docs say that one can use CONNECT AS to get an alias for a DB;
however, once I get the alias, I do not know the syntax.

In the following

+++
CONNECT "C:\MyDB.gdb" As DB1
USER 'sysdba'
PASSWORD 'masterkey';

SELECT * FROM MyTable;

+++

What is the syntax for referring to MyTable? "DB1.MyTable" produces an
error.

--
Todd Cary
Ariste Software
t...@aristesoftware.com

Team

Delphi Developer

Mon, 01 Dec 2003 04:18:13 GMT

Re:Accessing multiple DB's

Quote

Todd Cary wrote:

> The docs say that one can use CONNECT AS to get an alias for a DB;
> however, once I get the alias, I do not know the syntax.

I've only ever seen AS used in Embedded SQL, never in isql.

-Craig

--
Craig Stuntz (TeamB) Senior Developer, Vertex Systems Corp.
Delphi/InterBase weblog: http://delphi.weblogs.com
Use Borland servers; posts via others are not seen by TeamB.
For more info, see http://www.borland.com/newsgroups/genl_faqs.html

Other Threads

1. GPF's when running multiple exe's against a DB

2. OLE error 80040112 - using DAO TLB to access Access DB's

3. Multi 'Select' in Access DB

4. problem connecting to 'secure' Access DB

5. Searching multiple DB's...

6. Joining across multiple db's

7. Viewing multiple DB's

8. Multiple access to DB

9. Database access from multiple CGI's problem

10. Multiple OLE DLL's cause Access Violation