Jim B. Hadn't thought about a COUNT... good idea..
I was going to resolve to using specific SELECT blah,blah WHERE check_date = .vm_chkdate and clockno between 'specific numbers' AND LIMIT=1 to test to see if the data got loaded... The COUNT would likely be a faster solution.. Thanks Jim Limburg Jim Blackburn wrote: > > Jim: > You found that the error variable does not return errors from loading. The only >solution I have found is to count rows before and after loading. > > Jim Blackburn > Kodiak > > Jim Limburg wrote: > > > > Running this code: > > > > SET NULL -0- > > LOAD fouro1k + > > FROM &vg_chrfilepath USING clockno,fro1k_wages,fro1k_current,+ > > check_date,hours_worked ;NOCHECK;FILL > > SET VAR var_interr = .errvar > > IF var_interr = 0 THEN > > PAUSE FOR 1 USING 'Technituft loaded' AT CENTER CENTER > > ELSE > > PAUSE FOR 1 USING 'Loading Error ' at center center > > ENDIF > > SET NULL ' ' > > > > When this runs at run time... the PAUSE saying Loading > > Error pops up... > > > > During trace errvar and var_interr stay at 0 (zero). > > > > The data is loading which is what's important here.. > > but I would like to be able to count on the error > > variable to tell if it did.. > > > > If all else fails I will go to using a SELECT to see > > if the data go loaded, but I should have to.. > > > > Has anyone seen this before..? > > > > By the way, when I was running this code in version > > 6.1a I was doing a > > LOAD fouro1k + > > FROM &vg_chrfilepath AS ASCII... and it was working fine.. > > There are two more columns that the amount of fields > > that we are loading in. > > Now that we went to 6.5++ I had to modify the code... > > Upon a more detailed look at the Syntax I almost see why, > > but there isn't a real good explanation of what parts of > > the commands work with the new AS ASCII... or not? > > > > Jim Limburg
