VB ODBC SQL Advice

From: TS <twoshovel_at_yahoo.co.ku>
Date: Sat, 11 Oct 2003 01:56:22 +0100
Message-ID: <0zIhb.398$ca2.971335@newsfep1-win.server.ntli.net>

Posted on orafaq as well...

I am working on an _existing_ VB App connecting to an Oracle database (JBA) via ODBC and just wanted to be sure I understand the syntax.

The SQL statement is executing is:

SELECT OSLPDF3.MSWRKHDR.*, OSLD1F3.PARTS.* FROM ... ... WHERE OSLPDF3.MSWRKHDR.CONO40 = 'D1' ... Is this just [database].[table].[field]?

Do you need to reference the database if the tables are unique across the ODBC? Thanks
Ken Received on Fri Oct 10 2003 - 19:56:22 CDT