Do a SELECT COUNT(*) into vcount FROM tablename using the same where clause
as your choose statement adding where limit = 200.
If you have 200 rows get the user to enter something that will trim the
number of records down to a manageable size. Set the number to whatever
suits your users.
Ian
At 14:42 24/09/2001 -0400, you wrote:
>Is there a limit to the number of records that can
>be accessed using the #VALUES option of the CHOOSE
>command? I have a routine with this command that
>works fine when I limit the records to be accessed.
>However when I try to include all 4143 records without
>a limiting WHERE clause I get the following message:
>"Insufficient Memory to continue this function"
>It does bring up a menu but I have determined that
>it only includes 2780 of the 4143 records.
>
>In another office I have a client for whom this
>function worked fine. Then it just stopped working one
>day with the same message as above. However in her case
>it did not continue on and bring up any records at all.
>Did she just one day go over the limit for the number
>of records this function will handle?
