Posted by JTehonica on May 01, 2009 at 07:07:58: Uploaded files: 1
Does anyone know the best way to check to see if a record exists in a file? Attached is a file format description for a file, called N5. I need to do a query in this file to see if a record exists with certain criteria. I basically need to say, "Does a record exist in file N5 where Vendor = HVNBR$ and Check NBR = HCKNBR$ and Invoice NBR = HREFNBR$ and Check Date = myDateEntered".
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.