How foundset.search() works?

Classic Servoy
1

I would like someone could clarify some points about the search() method.

Does it execute a SQL against the DB everytime it is used? Sometimes you have a foundset in memory, let´s say a short foundset like a temporary cursor in FoxPro, and you need to check the existence of a record and it is not necessary to search over the DB but just in the cursor you have in memory.

I can see that doing a search() filters the records in the foundset. Is there a way to just point to that record in the foundset and not filtering it?

Thanks.

2

Juan,

foundset.search() always queries the database.
When you have the record in a foundset you can use foundset.selectRecord(pk) to find it.

Note that Servoy loads the PKs of a foundset in chunks of 200.
foundset.selectRecord does not query the database, but if the record does belong to the foundset, only the pk has not been loaded yet (when it belongs to the second chunk for example), then foundset.selectRecord(pk) cannot find it.

Rob

3

rgansevles:
Juan,

foundset.search() always queries the database.

Hmm, than why do we have to use sometimes the function: refreshFromDatabase, when there are new records, inserted outside Servoy?

4

Harjo,

That is to update foundsets that are shown already and need to be notified of a change in the data.

Rob

5

rgansevles:
Harjo,
That is to update foundsets that are shown already and need to be notified of a change in the data.
Rob

Just to make it clear:

The change of date inside Servoy (even if its a other user) is always sent to the already shown foundset,
by the Servoy-Databroadcasting.
The manually refresh is only necessary ,if the data is changed outside of Servoy, for example,
in the case of Foxpro is changing the dbf during servoy shows it in a foundset.

Is that true ?

6

yes