SetRange/FindFirst VS Get to find a record

samantha73

Hi
To find a record using the primary key we can use setrange/findfirst or Get. What are the differences between these two patterns? Does get throw an error if the primary key not found while findfirst in setrange will not error?
Thanks

ShaiHulud

If you do FindFirst or Get without error handling (if not FindFirst/Get), then both will throw errors.
When you know entire primary key, it's usually better to do Get for performance.
However! If you intend to pass the record into a report, then use SetRange on PK fields as report datasets operate on filtered records - using Get and passing it to a report will make the report run on entire table as if it wasn't filtered.