Re: SQR 3728

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

I usually get that error when I forgot to indent inside the select
statement.
I doesn't seem like that code should give that error, but maybe try:

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



Bob


-----Original Message-----
From: Philippe Godin [mailto:philippe.godin@VIDEOTRON.CA]
Sent: Wednesday, May 09, 2001 9:43 AM
To: SQR-USERS@list.iex.net
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.