FINDLAST issue

lisakins · 2008-02-21

I have made the Interaction Log Entry table in NAV 4.0 (SQL 2000) editable so that the salesmen can enter directly into a tabular form.

Because I do not wish to affect any other functions, I have created a new form that is on the contact card and shows the editable form where the profile answers usually are.

I get an error as soon as any field is clicked to initiate a new entry, because the entry no. is 0.

I am attempting to have the entry no, increment to the next available when they access this form. I put the following code in the OnActivate trigger:

IF InteractionLogEntry.FINDLAST THEN BEGIN
"Entry No.":=InteractionLogEntry."Entry No."+1;

I am receiving an error when I try to compile that states, "You have specified an unknown variable FINDLAST Define the variable under 'Global C/AL Symbols'.

This wasn't what I expected, but I'venever used the FINDLAST function before.

Can someone explain how I can correct this error and capture the last Entry No. + 1 on new records?

Alex_Chow · 2008-02-21

Findlast command only works with version 4.0 SP2 forward.

lisakins · 2008-02-21

Does the Find command work in 4.0 (SQL2000)?

If so, would I put something like:

IF InteractionLogEntry.FIND(+) THEN BEGIN
"Entry No.":=InteractionLogEntry."Entry No."+1;

Alex_Chow · 2008-02-21

Yes, that will work.

Since you're using SQL, it's highly recommended that you upgrade your executables to at least 4.0 SP3 and up.

lisakins · 2008-02-21

I did that and received the following error when I tried to compile:

"A value or expression was expected"

It then goes to the area of the code just after the + in the
FIND(+) THEN BEGIN

section.

Any ideas?

Ian_Piddington10199 · 2008-02-21

I think your code should read

IF InteractionLogEntry.FIND('+') THEN BEGIN
"Entry":=InteractionLogEntry."Entry No."+1
End;

The key bit it is complaining about is the (+) not being ('+')

regards

Ian

Alex_Chow · 2008-02-22

Good catch Ian... I didn't even realize that ' was missing... :oops:

lisakins · 2008-02-22

That was it exactly!

Thank you both for all your help.

FINDLAST issue

Comments

Categories