Saving found set of records

[madwill]

I know I've seen it somewhere. I've scanned the forum. I've searched my Scriptology index and contents. I've even stopped and thought for a few minutes. But I cannot remember how to Save a Found Set of Records. Can anyone help please?

[Vaughan]

There are two ways: reproduce the find process that found the set; or mark a field in each record and perform a find for the flag.

The first method is robust and reliable, though it will find any newly enterd records that also match the criteria (this could be prevented by including a search on a creation date field, for instance).

The second method breaks very easily in multi-user mode, when a second user performs a find and wipes out the flags from the previous user. It'll also break if a record is locked (when used by another user) preventing it from being marked as being in the found set.

Neither method will find records that have been deleted since the origianl find was made.

[ernst]

Third method:

Supposing all records in the database you're searching in have a textfield with a serialnumber you could do a 'copy all records' command on a separate layout that only shows the serialnumber field.

Next step would be to paste the clipboard into a textfield to store the serial numbers.

To recall you could do a 'show related records' using a relation between the textfield from the previous step and the serial number field.

Drawback is the limitation of the size of the textfield you use for storing the found serialnumbers. This limit is 64000 characters, so if your serialnumebr is 9 characters you could only store the serial numbers of 6400 records. (64000 characters / (9 characters + CR))

Regards,

Ernst.

[madwill]

Thanks to you both. I reckon the flag method, for its simplicity, is probably my best bet, as users are strictly limited to 2 (it's our invoicing system!). But the third method is the one that seems to ring a bell. Anyway thanks again.

Regards

MadWill

[Vaughan]

I think you missed my point. If you have more than one simultaneous user the flag method will fail. Think about it.