Re: problem in sqr in begin-select statement

[Stan Quick <stanley.quick@BRIO.COM>]

Have you tried to make the table reference dynamic?

begin-procedure main1
let $tablename = 'tabletest'
begin-select
name
  from [$tablename]
end-select


-----Original Message-----
From: GIRIDARAN SUNDARARAJAN [mailto:savegiri@YAHOO.COM]
Sent: Friday, November 16, 2001 1:46 AM
To: SQR-USERS@list.iex.net
Subject: problem in sqr in begin-select statement


Hi all

i have a problem here and i have given the test code
too.

In the below program i have set a status flag to 'n' .

hence the procedure main2 gets executed . but if i
delete the table

'tabletest' in the back end, then a compile time error
comes

that 'table or view doesnt exist' though i am not
calling the

procedure main1 at any point of time in the program.

plz help me how to overcome this un-called for compile
time validation of my select statement




-------------------------------------------------------
Begin-program

let $status ='n'

if $status = 'y'

do main1

else

do main2

end-if


End-program


begin-procedure main1

begin-select
name
  from tabletest
end-select

end-procedure


begin-procedure main2
 display 'select not executed'
end-procedure


-----------------------------------------------------
Thanking you in advance

Regards
s.giridaran



__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com