problem in sqr in begin-select statement

[GIRIDARAN SUNDARARAJAN <savegiri@YAHOO.COM>]

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