[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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