Sharon,
The choose is limited by available memory. It all depends on the number of
items and columns displayed. I've limited in my application to around 500
items to display (by code). If that number is exceed then I break the items
into sub set for the choose display. Displaying three columns of
information Alphaname, itemno, itemdescription the max I could get to
display was around 900 before the choose would generate an error
message.(comments limited to 6.5+ or 6.5++ windows only)
best regards,
Oma
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of SHARON LIMA
Sent: Monday, September 24, 2001 1:42 PM
To: Rbase List
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?
