Lookup Problem

KSP_NAV

Hi,

The below coding is written in the "OnLookup" trigger of the table X. The problem is the value is not getting updated in the field but it is displayed in the message.

LGenJnlTemplate.RESET;
LGenJnlTemplate.SETRANGE(LGenJnlTemplate.Recurring,TRUE);
CASE LGenJnlTemplate.COUNT OF
1: BEGIN
LGenJnlTemplate.FINDFIRST;
LGenJnlBatch.RESET;
LGenJnlBatch.SETRANGE(LGenJnlBatch."Journal Template Name",LGenJnlTemplate.Name);
LFrmGenJnlBatches.SETTABLEVIEW(LGenJnlBatch);
LFrmGenJnlBatches.SETRECORD(LGenJnlBatch);
LFrmGenJnlBatches.LOOKUPMODE(TRUE);
IF LFrmGenJnlBatches.RUNMODAL IN [ACTION::OK, ACTION::LookupOK] THEN BEGIN
LFrmGenJnlBatches.GETRECORD(LGenJnlBatch);
"Rec. Journal Batch" := LGenJnlBatch.Name;
MESSAGE(LGenJnlBatch.Name);
END;
END;
2:
.
.
END;
CLEAR(LFrmGenJnlBatches);

The same set of codes works fine in the Form but in my case it should work in table.

Can anyone help me to sort this problem?

Thanks in advance

manlue

Hi,

first impression to me is that a "MODIFY" is missing to save the new value in the table...

KSP_NAV

Hi,

Thanks for your reply.

I have already tried with MODIFY and the new value is not updated

lyot

For as far as I know code written in LookUp trigger only works when used in forms...

KSP_NAV

Nope, have a look in the "Applies-to Doc. No." etc... fields in table 36

KSP_NAV

Is there any possibilities for my query? As i am running out of time, can anyone help me in this regard?

Albertvh

Hi,

What is "Rec. Journal Batch" is this a record variable or a field name of the table you are trying to update?

maybe it should be "Rec. Journal Batch".Name := LGenJnlBatch.Name;

Hope this helps

KSP_NAV

"Rec. Journal Batch" is a field in which i need to update the General Journal Batch Name.

After the field assignment, if i message the "Rec. Journal Batch" field, it is displaying the desired output. The problem is that the value is not updated in the table.
"Rec. Journal Batch" := LGenJnlBatch.Name;
MESSAGE("Rec. Journal Batch");

manlue

What kind of type is your field "Rec. Journal Batch"?

KSP_NAV

It is Code 10

manlue

So this should be updated if modified. As I first replyed I think a modify-command must be to save the modified value in table. Only idea is to check if there's any other following code which will rollback your modification after having displayed it. Is the code you provided us the whole code in that trigger? Did you debug it to check step by step when field value changes?

If there's more code which is done you may provide it... maybe anyone in this forum then has a good idea...

daros

How have you tried? Run the table? If so try to use any form. NAV has a problem with written lookup in the field when use run table.
Do not use modify in lookup.

KSP_NAV

Thanks Daros, as you said i have been trying this only at the table level and now i created a Form and performed the lookup and it works as expected.

Thank you everyone for your timely help.