| Directives |
|
| Format | NEXT RECORD |
| Description | Use the NEXT RECORD directive to end a SELECT directive. As each record is read, ProvideX processes any logic you include following the SELECT directive up to the NEXT RECORD. When ProvideX encounters a NEXT RECORD statement with no records found for a nested SELECT, it will locate the corresponding SELECT statement. |
| See Also | SELECT Select/Query From ... Where |
| Example | 0010 SELECT IOL=0100 FROM "CUST_FILE",KNO=1 BEGIN "ABC CO" END "NEW CO" WHERE 0010:CITY$="CLARENDON" 0020 PRINT REC(IOL=0100) 0030 NEXT RECORD 0100 IOLIST CUST$,NAME$,ADDR1$,ADDR2$,CITY$,PROV$,POSTAL$,INV_DT$,AMT,TERMS, 0100:DUE_DT$ 0110 PRINT "DONE"; END -:run 123460 ACME LTD. SUITE 1900 2000 1ST ST. CLARENDON ON K0K0K0 0 |