Re: Forms, fetch 100 records

I assume you are already using the Long List = True LOV attribute, and this is where the user forgets to enter a selection criteria.

If this is the problem, then I would create another field in a control block somewhere on your form for the user to enter a selection criteria value. Until this value is entered, and a Select Count(*) from your table based on the criteria returns a small enough number, do not allow the LOV to be used.

When a good selection-criteria value is entered, populate the record group manually with populate_group_with_query command, and allow the LOV to be used.

Also turn off LOV validation to the field, and in the Key-ListVal trigger make sure the selection criteria is ok before doing a List_Values.

Hope this helps.
Steve Cosner
http://members.aol.com/stevec5088

In article <73239e$3g0$1_at_nnrp1.dejanews.com>,   phpconsult_at_my-dejanews.com wrote:
> Hi
>
> My problem is, that I have a List of value with a huge amount of records
> (400.000). If a user forget to put in a selection criteria forms will fetch
> all the records, and the system is locked for a couple off houres. How can I
> give a message when more than 100 records is in the selection criteria?
>
> Hope You can help me.
>
> Regards Peder Hostrup-Pedersen / Denmark

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 03:04:56 CET