Re: my problem

["Chandrashekhar.A.M" <chandram@ZENITHSOFT.COM>]

hi paul

    the code u have sent is not working. it is giving the following error

 

(SQR 3721) Bad param found on 'BEGIN-SELECT' line; Format is:
 BEGIN-SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn]
              [ON-ERROR=procedure[(arg1[,argi]...)]]
Begin-Select -DB'DSN=Sales;UID=scott;PWD=tiger'

 

what can i do for this

bye

chandru

 

----- Original Message -----

From: Paul Hoyte

To: SQR-USERS@list.iex.net

Sent: Wednesday, January 03, 2001 2:38 PM

Subject: Re: my problem

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