Also, If you absolutely have to have a Huge Choose, I have an ActiveX
control on my site that does not have the limitations of RBase. It should
hold about 32767 items if you should have to have that many. It also has a
WalkMenu behaviour which is the standard for VB listboxes. There is RBase
sample code there (both on the VBscript side and RBase) to show how to make
a connection to the database, fill the listbox and get a return value of the
selection into RBase.
mike
----- Original Message -----
From: "SHARON LIMA" <[EMAIL PROTECTED]>
To: "Rbase List" <[EMAIL PROTECTED]>
Sent: Monday, September 24, 2001 1: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?
>
>
