SELECT statement limitations
Posted: Tue Oct 08, 2019 9:57 pm
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
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