Usually the user has a vague idea of what they are looking for. So perhaps
you can limit your choose by first asking to input the first three letters
of a name or the first digit of a part number, etc. Then use the LIKE in
your where clause.
Bernie Lis
Megabytes, Inc.
----- Original Message -----
From: "SHARON LIMA" <[EMAIL PROTECTED]>
To: "Rbase List" <[EMAIL PROTECTED]>
Sent: Monday, September 24, 2001 2:42 PM
Subject: Choose Command
> 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?
>
