Re: sql select question, GETTING OUT?

["Singh, Rajvirendra NY ESA" <RajvirendraSingh@EXCHANGE.ML.COM>]

use exit-select within your begin-select......end-select

        -----Original Message-----
        From:   Dominick Logiudice [SMTP:dlogiudice@PINE.VPCC.SUNYSB.EDU]
        Sent:   Monday, October 26, 1998 12:05 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        sql select question, GETTING OUT?

        If i have a sql select for example

        begin-procedure GET-DATA
        !display 'in GET-DATA'


        begin-select

        PD.EMPLID
        PD.NAME
        PD.SSN
        PD.PHONE_ID

                ! ** IF I FOUND AT LEAST ONE I WANT TO GO TO
                ! ** PROCEDURE EXIT , HOW DO I DO THIS ?

                   LET CURR_PHONEID = PD_PHONE_ID


        FROM PS_DATA PD


        WHERE PD.SSN = &A.SSN

        end-select

        End-procedure GET-DATA