Search Form opens on a record, need to disable this

Classic Servoy
1

Hi, I have a form with a search function etc. The problem is, when the form is opened it opens a record without the user typing anything in the search box.

Basically I need it to not display record unless the user types the record ID in the search box and clicks the button which involves the search funtion code.

Any ideas?

2

If you want this for one from only: Set the namedFoundSet property of your form to -empty- in the properties view.

If you want this for all forms: Call databaseManager.setCreateEmptyFormFoundsets() in the onOpen method of your solution.

3

Thanks for reply, do you know how to select more than 200 records. I.e when I open the form, on the navigator it shows 200 records, then when you scroll down it shows the next 200.

When I am filtering the records, I have set up a text box that shows the number of records filtered but it shows this as 200 even though there are 1000’s.

Do you know how to look at the whole table rather than just 200 at a time, if that makes sense?

Thanks

4

Servoy doesn’t load more than 200 records by default for performance reasons. It will only load the next records when you need them, for example when scrolling down. In most cases the end users will not do that however, so then getting all the 1000s of records is a lot of overhead.

If you want to know the total number of records, you can use ```
databaseManager.getFoundSetCount(yourfoundset);