Form Field OnAfterValidate event is not called ??

aquawater

The subject is exactly what I am wondering.
Here is the story..

There is a customization on Purchase Line table,
Field: No.
Event: OnLookUp
This custom lookup will call Item Vendor catalog (if the type is ITEM) and call Validate after Item No. is selected.

The problem is in Purchase Order form, OnAfterValidate event is not called after user select Item No (it doesn't trigger InsertExtendedText method). We need this because we need to use Auto. Extended Text in Purchase Line.
The corresponding Item has been setup correctly.
Any advice?
Or how do I call InsertExtendedText after user select Item No?

But please do not advice me.. 'you should just use the standard/default lookup' and stuff like that... :whistle:
Thanks in advance.

kine

1) All depends on the lookup function, which lookup is changed? On the form or on the table? If on the form, ends the function with Exit(True) when something is correctly selected?
2) You can hit some issues when inserting extended text from OnValidate trigger. E.g. in situation, when you insert the extended texts, but the OnModify of the line will end by error. In this case, you have the extended texts inserted but the change of the No. field is not saved. Or when you call the OnLookup and OnValidate of new, inserted line. How you will insert the extended texts, when you do not know Line No. yet?

garak

thats a know feature. Why do you not use the TableRelation property to run the lookup?

aquawater

kine wrote:

1) All depends on the lookup function, which lookup is changed? On the form or on the table? If on the form, ends the function with Exit(True) when something is correctly selected?
2) You can hit some issues when inserting extended text from OnValidate trigger. E.g. in situation, when you insert the extended texts, but the OnModify of the line will end by error. In this case, you have the extended texts inserted but the change of the No. field is not saved. Or when you call the OnLookup and OnValidate of new, inserted line. How you will insert the extended texts, when you do not know Line No. yet?

I mentioned the lookup is changed on TABLE.

"There is a customization on Purchase Line table,
Field: No.
Event: OnLookUp"

kine

Ok, than the OnAfterValidate will not be triggered, because the validation is started on table level, not on the form level. It is why it is better to write code on tables, not on forms...