Error message Employee No. " does not exist

poppins

Hi everyone,

I got the following error while trying to run a form :

Employee No. " does not exist

I tried to debug the C/AL code, the error seems to be in this line:

Employee.GET(GETFILTER("Employee No."));

I checked the Employee table, the Employee No. already exists in the table....

What should I do???

mohana_cse06

poppins wrote:

Employee.GET(GETFILTER("Employee No."));

Did you try

Employee.GET("Employee No.");

Chinmoy

If you want avoid this error.. you can put:

IF GETFILTER("Employee No.") <> '' THEN
Employee.GET(GETFILTER("Employee No."));

However, I suggest, you find out why the filter on "Employee No." field is not set, when it is expected to be.

Chn

poppins

mohana_cse06 wrote:

poppins wrote:

Employee.GET(GETFILTER("Employee No."));

Did you try

Employee.GET("Employee No.");

Yes I did, same error message...

mohana_cse06

In which trigger you have the above code?
Either you have it in place where record is not get like OnOpen or the employee code is blank in record..

vijay_g

The error is coming because of you are not assigninn any filter to emp no. while running this to avoid this error try this code

IF GETFILTER("Employee No.") <> '' THEN
Employee.GET(GETFILTER("Employee No."));

poppins

mohana_cse06 wrote:

In which trigger you have the above code?
Either you have it in place where record is not get like OnOpen or the employee code is blank in record..

The code is in the trigger OnOpenForm()...
I checked, the employee code is not blank...
So, what should I do???

mohana_cse06

You will not have record in OnOpen form

you have to shift the code to OnAfterGetRecord..

to check simply add

Message('%1',"Employee No.");

ufuk

Is this a card or list type form? If it is card then it doesn't matter using OnOpenForm (but not triggered when switching between records) or OnAfterGetRecord triggers. If it is a list then you can use OnAfterGetRecord trigger. All depends what you are trying to do.