Very often when developing we have logic we would like to execute on records, but only when the table is actually a real table and not when used as a temporary record. This could be things like inserting, modifying or deleting attached records in another table which would make no sense in most cases if the table you are currently in is temporary.
Now when we use a RecordRef we have a command that will return true or false based on the RecordRef in question is temporary or not. The command is called
However this command sadly doesn’t exist for Records.
So how can we get around that issue?
I have created a RecordRefLibrary codeunit that contains the following 2 functions among others
IsVariantTemporary(PassedVariant : Variant) : Boolean
Variant2RecRef(PassedVariant : Variant;VAR RecRef : RecordRef)
CASE TRUE OF
RecRef := PassedVariant;
Now in each table where I need it I add the following function
IsTemporary() : Boolean
Now I can write
anywhere I use the Record and it will return if the record I am currently in is temporary or not.
I could of course also just call directly to the codeunit if I would like not to make changes to the Table, however it would be good practice in my view to expose the functionality on each table where needed, so everybody knows where to find it.
Hopefully this was helpful to some of you if you don’t have a solution for this already.