Multiple Selects from Basic program

I noticed that when I executed two select statements in a basic program, the 2nd one does NOT utilize the results from the first one:

CMD1='SELECT FILE WITH ATTR1 EQ "Y"''

EXECUTE CMD1

CMD2-'SORT FILE F1 F2 F3 F4'

EXECUTE CMD2

But, if I combine them it works:

MULTI.CMD=CMD1:@AM:CMD2

EXECUTE MULTI.CMD

Problem: is there a way to keep the 2nd command from running if the CMD1 finds 0 records?

I noticed that when I executed two select statements in a basic program, the 2nd one does NOT utilize the results from the first one:

CMD1='SELECT FILE WITH ATTR1 EQ "Y"''

EXECUTE CMD1

CMD2-'SORT FILE F1 F2 F3 F4'

EXECUTE CMD2

But, if I combine them it works:

MULTI.CMD=CMD1:@AM:CMD2

EXECUTE MULTI.CMD

Problem: is there a way to keep the 2nd command from running if the CMD1 finds 0 records?

I noticed that when I executed two select statements in a basic program, the 2nd one does NOT utilize the results from the first one:

CMD1='SELECT FILE WITH ATTR1 EQ "Y"''

EXECUTE CMD1

CMD2-'SORT FILE F1 F2 F3 F4'

EXECUTE CMD2

But, if I combine them it works:

MULTI.CMD=CMD1:@AM:CMD2

EXECUTE MULTI.CMD

Problem: is there a way to keep the 2nd command from running if the CMD1 finds 0 records?

EXECUTE CMD2:' REQUIRE.SELECT'

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

Doug,

Explain 'RETURN.SELECT'.  not in any UniVerse manuals and I am not sure how to utilize it.

Nelson

SORRY - REQUIRE.SELECT.

is this an option for EXECUTE?