paulc wrote:HI harjo
If a user was to perform a find on a foundset, omit some records, and perform the original find again, will they get the original results?
yes, if the second find, exactly the same as the first find, you will also see the omitted records again.
Or will I need to perform one of the following functions loadAllRecords, loadRecords(dataset), loadRecords(sqlstring), invertRecords() to achieve the original result set?
I think what you have to do, is store your searchresults (or better your foundset)
that can be done multiple ways.
1. foundset.duplicateFoundSet() - this will make a snapshot of your foundset, you can store that in a MEDIA global (storing it in a blob you have to serialize, it first I think)
2. databaseManager. getSQL() & databaseManager. getSQLParameters() - with those two, you can retrieve the SQL & parameters of the current foundset and store that.
Hope this helps.....