I am wanting to base an IF statement on the existence of a number in a table, however I receive the following error with my attempt, which is
IF vsnew IN (SELECT secno FROM sections WHERE sno=.vsno) THEN . -ERROR- Sub-SELECTs are not supported by this command. (2310) I was wondering if the only way of achieving this to do a SELECT INTO (or similar) to determine if any values exist that meet the criterion or, is this possible, but my statement is incorrect ? Any suggestions would be much appreciated. Thank you. Regards, --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
