Re: SQR 3728

[Chandrakant Joshi <Chandrakant_Joshi@PUTNAMINV.COM>]

Hi,
             The SQR we are using is 3.x.
Your syntax should be something like this if you are using that,

Begin-Select
location  &TEMP
   move &TEMP to $TEMP
   move &TEMP to $TEST
from locations
end-select

Incase if you wnated to move the value of location into two variables
TEMP and TEST.   Hope this helps. No "Into" statements.
It just puts the value of location column to &TEMP varaible.
Then we can use it however we want it.

Joshi





Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR, Brio Technology's database reporting
      language" <SQR-USERS@list.iex.net>


To:   SQR-USERS@list.iex.net
cc:
Subject:  SQR 3728


Good day,

    I've went thru the library to find my answer but couldn't find it,
perhaps someone can help...

 What i'm trying to do is a select into command. This is what I have:

Begin-Select
location
into TEMP Test
from locations
end-select

    This gives me the following error:

Error on line 9:
   (SQR 3728) SQL expression not ended, perhaps missing &name.
from locations

Errors were found in the program file.

SQR: Program Aborting.

Cursor Status:

 Cursor #1:
 Not processed due to report errors.

Anyone knows how I can achieve this and if using this statement can be done
by a user that don't have the rights to create a table???

TIA

Philippe Godin
CiM Maintenance Inc.