Page 1 of 1

SELECT statement limitations

Posted: Tue Oct 08, 2019 9:57 pm
by RobboRobson
Hi

I want to read through a large file containing about 10 milion records

I've used the following command:

Select Fields(*ALL) From_File(LDGP010) Io_Error(*NEXT) Val_Error(*NEXT)

But when running the form I'm getting the following error message appearing:

(0222) - Selection Record Limit of 10000 exceeded

I thought the limit for records only applied to lists and grids not actually looping through a large file?

Regards


Paul

Re: SELECT statement limitations

Posted: Tue Oct 08, 2019 10:37 pm
by RobboRobson
Please ignore someone had used the Connect_File in the program