Re: forms 5 - number of rows in form

"pat saunders" <pat.saunders_at_sis.securicor.co.uk> wrote in message news:bc0e3bd8.0210280341.64f3a8d9_at_posting.google.com...
> Hi,
> I am new to forms so sorry if question is really easy to fix!!
> I am using forms V5.0
> We have a form that display's every row in a database table. It also
> has a scroll bar.
> It has a Pre-insert trigger that limits the user to entering no more
> than 79 rows of data.
> This limit needs to be upped to around 90. Apart from upping this
> limit in the pre-insert trigger , Are there any other changes
> I need to make, I.E would the form / scroll bar automatically resize
> to show these extra rows etc etc
> Any help appreciated.
> ta

Scroll bars, if you have them, take care of themselves. No need to do anything.

Careful about displaying ever recoird in the table. If the table is big then the Execute_Query call can take ages if you have the block proprty to retrieve all records set. IF you don't then the scrollobar will only reflect the records retrieved so far.

I'm curious about limiting number fo records inserted int he PRE-INSERT trigger though. How are you doing this as this doesn;t sound like the best approach to me. Are you kepping some sort of count in a global (yuck!) variable or what. The user will enter (say) 100 records. The 80th one will fail by the PRE-INSERT trigger which will then cause a rollback causing no records to hit the database. Is this your design? Better to stop, somehow, the users from entering too many records rather than failing the insert at commit time after they've done all the typing.

This is the second post I've read today about restricting the number of records inserted in Forms. Why would you want to do this? Received on Mon Oct 28 2002 - 13:50:39 CET