- What does FINDSET do (I did not find any help in the C/SIDE Reference Guide)?
This function as (couple others) performs the same tasks as FIND, but is designed specially for SQL server option and is more efficient.
I found that info in C/SIDE Referencing guide presents starting from v.4.0 SP1:
Use this function to find a set of records in a table based on the current key and filter. The records can only be retrieved in ascending order.
Ok := Record.FINDSET([ForUpdate][, UpdateKey])
3)Is it advisable to use COPY instead of := ?
If u really need to copy the same filters etc. (as Claus wrote) to the new record from origin.
As for me it’s more easy to manage all needed conditions instead remembering that from early, that’s why I often use :=
But it depends- what you prefer (or can :).