What does this Find statement exactly do?

GeorgeWaenn

Hi there,

I'm fairly new to NAV (4.0 SP3) and I came across this snippet of code in codeunit 333:

IF NOT FIND('=><') THEN ...

What does this do? Is it to test if a recordset is empty? I don't quite get it. Hopefully someone can shine some light on this!

Best regards,

George

lvanvugt

You will find this code in all kinds of codeunits, that, one way or another, have to do with posting journal-like records:

IF NOT FIND('=><') THEN BEGIN
    "Line No." := 0;
    COMMIT;
    EXIT;
  END;

FIND('=><') it is checking whether it can find a specific 'journal' line ('=') or a line after ('>') or a line before ('<').
So, yes, with the NOT combined the condition evaluates to TRUE when the recordset is empty.

GeorgeWaenn

lvanvugt wrote:

You will find this code in all kinds of codeunits, that, one way or another, have to do with posting journal-like records:

IF NOT FIND('=><') THEN BEGIN
    "Line No." := 0;
    COMMIT;
    EXIT;
  END;

FIND('=><') it is checking whether it can find a specific 'journal' line ('=') or a line after ('>') or a line before ('<').
So, yes, with the NOT combined the condition evaluates to TRUE when the recordset is empty.

Thanks Luc. What's the advantage of the above construction compared to an ISEMPTY?

David_Singleton

This command is outdated, and really does not need to be used.

Here is a wiki entry about it:

http://wiki.dynamicsbook.com/index.php?title=Find_any_record_in_a_record_set_in_Dynamics_NAV

GeorgeWaenn

Thanks David, that makes things clearer.