VB ODBC SQL Advice - 10-10-2003 , 07:56 PM
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
Re: VB ODBC SQL Advice - 10-13-2003 , 02:12 AM
In article <0zIhb.398$ca2.971335 (AT) newsfep1-win (DOT) server.ntli.net>,
twoshovel (AT) yahoo (DOT) co.ku says...
"schema"). Search google groups for "public synonym" and "schema" if you
don't want to specify schemas every time.