Onlookup trigger issue

gemini_shooter
Member Posts: 149
Hello All,
I created a table and form for multiple customers that can be attached to a job. The link is available from the job card and you can enter multiple customers for a job. However the form has a default lookup mode of false when started from job card, which is what I want
However, I also have the same link on job task line but this time I want the form to start in lookupmode of TRUE, but had some issues with validation and get an error on the validation line on the form trigger? How would do the same code for a page, do I just replace the form variable with a page variable ?
Field validation on table
I created a table and form for multiple customers that can be attached to a job. The link is available from the job card and you can enter multiple customers for a job. However the form has a default lookup mode of false when started from job card, which is what I want
However, I also have the same link on job task line but this time I want the form to start in lookupmode of TRUE, but had some issues with validation and get an error on the validation line on the form trigger? How would do the same code for a page, do I just replace the form variable with a page variable ?
Job Promotion Customer - OnLookup(VAR Text : Text[1024];) : Boolean
//Testing
CLEAR(lrecJobPromoCust);
CLEAR(gjffrmJobPromoCust);
lrecJobPromoCust.SETFILTER(lrecJobPromoCust."Job No.", "Job No.");
gjffrmJobPromoCust.SETTABLEVIEW(lrecJobPromoCust);
//gjffrmJobPromoCust.EDITABLE(FALSE);
gjffrmJobPromoCust.LOOKUPMODE(TRUE);
IF gjffrmJobPromoCust.RUNMODAL = ACTION::LookupOK THEN BEGIN
gjffrmJobPromoCust.GETRECORD(lrecJobPromoCust);
VALIDATE("Job Promotion Customer", lrecJobPromoCust."Customer No.");
MODIFY;
END;
Field validation on table
CLEAR(lrecJob);
IF lrecJob.GET("Job No.") THEN
IF NOT lrecJob.Promotion THEN
ERROR(ltxt002);
IF (("Job Task Type" <> "Job Task Type"::Posting) OR
("Rebate Type" <> "Rebate Type"::" ")) THEN
ERROR(ltxt001);
IF "Job Promotion Customer" = '' THEN
"Promotion Expense Ship-to Code" := '';
0
Comments
-
What error message you are getting?0
-
There is no Job Promotion Customers within the filter.
Filters: Job No.: A0010 -
Can you check with debugger..where exactly you are getting this error?0
-
I did, it just stops at the line below on the form lookup trigger and just says 'error' and doesn't even go inside the validate trigger
VALIDATE("Job Promotion Customer", lrecJobPromoCust."Customer No.");0 -
lrecJobPromoCust.SETFILTER(lrecJobPromoCust."Job No.", "Job No.");
and also setrecord after settableview
Better RESET lrecJobPromoCust before SETFILTER..0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions