Re: my problem

[Paul Hoyte <phoyte@SHARIDIONNE.COM>]

Try this solution that was provided by "FRANCK MASSON" another user on the list.....

try something like this

Begin-Procedure Main

Begin-Select -DB'DSN=Sales;UID=scott;PWD=tiger'

Ename, Job, Hiredate, Sal, Commission

Do Insert

>From Emp

End-Select

End-procedure ! Main

Begin-procedure Insert

Begin-SQL -DB'DSN=Archive'

insert into EmpArch (ename, job, hiredate, sal,

commission) values (&Ename, &Job, &Hiredate, &Sal,

&Commission)

End-SQL

End-Procedure ! Insert

 

Paul Hoyte
Sharidionne, Inc.
(248) 559-6868
www.sharidionne.com
phoyte@sharidionne.com

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Chandrashekhar.A.M
Sent: Thursday, January 04, 2001 5:42 AM
To: SQR-USERS@list.iex.net
Subject: my probelm

hi all

    I am working on SQR ver 5.0 with back end oracle 7.3 on windows.

Now what is my problem is that I have two or three different ODBC Data Source Names. and i want to use these DSN's in a single program.  but while running SQR program it will ask one DSN after that how can i change to another schema or DSN.

 

thanks in advance

chandru