Comparing two record variables

Belias · 2010-09-13

I don't know if it's risky, or if it's a known habit of you guys, but sometimes i want to compare two record varibales and see if they're the same (i mean, through code). i also noticed that FORMAT function works with record variables.
Is there something wrong (or is there a better way to do it) in doing this?

IF FORMAT(mytablevariable1) = FORMAT(mytablevariable2) then
  //record variables are pointing exactly to the same record
else
  //one or more field values are different

i think it is self documenting and smart, but i'm probably missing something...is it possible that nav does not have a function to compare two record variables? :-k

jlandeen · 2010-09-13

I've thought of several ways to code that type of request and I haven't seen anything like a single function that compares all values in the fields.

One thing I've seen done in the past is to use record ref variable and lookup the fields that are in the record and compare them. I think that's another way of comparing the records together....althought the format(recorda) = format(recordb) is probably just a good.

kine · 2010-09-13

It is good idea until the record is not too big to have more than 1000 chars when converted into text... ;-) Of course, using the recordref and fieldref to compare all fields is the clearest way.

jlandeen · 2010-09-13

gah....I always forget about the size limits of the text datatype in NAV!!! Although I guess 1024 is better than the 250 or whatever it used to be!

Belias · 2010-09-14

yeah, the message text limit...it's something you know but you never think about :whistle: thanks!

jlandeen · 2010-09-14

Yeah that only thing that has more room than a large text variable is a BLOB or BigText datatype and those wouldn't really be useful in this situation.

If only we could have access to the 2Gb string data type like in C#/VS.Net!

DmytroY · 2024-06-10

Where did you get 1024 limitation? For Text variable 'no limits'
"If no length is specified for text variables, the length is unlimited."
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-object-specifications-limitations

FORMAT(Rec) limitation : If, when the system formats Value, the result is a value larger than the maximum length MAXSTRLEN method (Code, Text) of String, a run-time error occurs.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/system/system-format-joker-integer-string-method

But MAXSTRLEN(TextVariable) = 2,147,483,647.

So, I compared:
if Format(Rec) <> Format(xRec) then

And it works on BC 16, OnPrem, AL extension.

TallyHo · 2024-06-11

@DmytroY
You are addressing a 14 year old post.. a lot has changed.

Comparing two record variables

Answers

Categories