Re: SQR - select statement how to question

[Yogesh Shashikant Kulkarni <yogeshk@KANBAY.COM>]

Try this one :

        begin-select  a

>      do abc
           let $Found = 'Y'

       from table_a
> where table_a.unique_field = "1234"
         end-select

        if $Found <> 'Y'
>     do xyz
> end-if
>
      end-procedure


...Yogesh


> ----------
> From:         Rhonda Hudgins[SMTP:rhudgins@GENENCOR.COM]
> Reply To:     sqr-users@list.iex.net
> Sent:         Friday, May 19, 2000 10:25 PM
> To:   SQR-USERS@list.iex.net
> Subject:      SQR - select statement how to question
>
> I need to work with a  select statement as follows but I am not sure how
> to
> write the SQR and/ or sql to do this
>
> select  a from table_a
> where table_a.unique_field = "1234"
>
> IF record is found
>      do abc
> else
> if record is not found
>      do xyz
> end-if
>
> I would appreciate any help and suggestions.
>
> Rhonda Hudgins
> Genencor International, Inc
> rhudgins@genencor.com
> 716/256-5266
>