Re: sql select question, GETTING OUT?

[SEMECH <jstein@MAIL.NETVISION.NET.IL>]

Try : EXIT-SELECT

Arnon
-------------------------------------------------------------------
SEMECH SOFTWARE MARKETING LTD.
TEL : (972) - 3 - 5333144
FAX : (972) - 3 - 5333132
Email: <semech@pobox.com>
------------------------------------------------------------------
-----Original Message-----
From: Dominick Logiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: 26/10/98 19:15
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
>