If you execute "SELECT SOMEFILE" rather than the basic SELECT statement then you can get the number of items selected with the basic SELECTINFO function on UV or with @SYSTEM.RETURN.CODE on UD.
Regards, Steve On Tue, Oct 19, 2010 at 10:41 AM, George Gallen <[email protected]>wrote: > UV here > > I open a file, then use SELECT filevarible then proceed to do a > LOOP/READNEXT/REPEAT to > scan through the file. > > OPEN "","SOMEFILE" TO F.TEST ELSE STOP > SELECT F.TEST > LOOP > READNEXT ID ELSE EXIT > REPEAT > > Is there any way to know how many records WILL BE processed in that loop > before scanning? > > @selected doesn't work, it only returns the number of items in the last > group that was read > > I tried using SELECT filevariable TO list.variable .... but you can't do a > DCOUNT on that variable > you can only READNEXT FROM list.variable > > Aside from EXECUTE "SELECT filename" RTNLIST in place of the SELECT > filevariable so that > @selected would return with the actual number selected (which does do what > I want) > > Any other methods? > > > George Gallen > Senior Programmer/Analyst > Accounting/Data Division, EDI Administrator > [email protected] > ph:856.848.9005 Ext 220 > The Wyanoke Group > http://www.wyanokegroup.com > > > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
