You can put -DB in your BEGIN-SELECT
statement. Look up BEGIN-SELECT in yr sqr help
file.
-DBconnection string - (ODBC) Specifies the ODBC connection string for
this SELECT paragraph only. A conection string has the following
syntax:
DSN=data_source_name[ ;keyword=value[ ;keyword=value ;...]]]
For example, a connection string for an Oracle data source named
"ora7" might look like the following:
'DSN=ora7;UID=scott;PWD=tiger'
Function
Begins a SELECT paragraph. A SELECT paragraph
is the principal means of retrieving data from the database and printing it
in a report. A SELECT paragraph must be inside a PROCEDURE or PROGRAM
section
Syntax
BEGIN-SELECT [ DISTINCT ] [ -Cnn
] [ -Bnn ] [ -XP ] [ -NR ] [ -SORTnn ]
[ -LOCK {
RR | CS | RO | RL | XX } ] [ -DBdatabase ] [ -DBconnection_string ]
[LOOPS=nn ]
[ ON-ERROR=procedure [ ( arg1 [, argi ] ... ) ]
]
END-SELECT
Note: When arguments span multiple lines, terminate
the first line with the continuation character (-) or indent the argument on
the following line. Otherwise, the argument on the following line will
be misconstrued as a SELECT column.
Hello.
What would be the proper syntax to open and ODBC connection to
another database within and SQR.
Robert
