Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
S3 Customization/Development
TAEEMASTER FILE
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jeffin Joy
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
4988
People Online:
Visitors:
77
Members:
0
Total:
77
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1377
Roger French
1315
mark.cook
1244
Chris Martin
825
Forums
Filtered Topics
Unanswered
Unresolved
Active Topics
Most Liked
Most Replies
Search Forums
Advanced Search
Prev
Next
Forums
Integration / Customization
S3 Customization/Development
TAEEMASTER FILE
Please
login
to post a reply.
4 Replies
0
Subscribed to this topic
19 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Chesca
Veteran Member
Posts: 490
New Poster
Congrats on posting!
3/31/2012 8:54 PM
How to perform a DB call to get a single record off the TAAMATER FILE? I am not sure how to populate the index key and use the 840-FIND-TEMSET1 or the 850-NLT-NEXT? Thanks
Ragu Raghavan
Veteran Member
Posts: 477
New Poster
Congrats on posting!
Engaged Poster
Wow, you're on a roll!
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader art thou!
4/1/2012 7:56 PM
Split
DO you have access to the Lawson support site ? There is a document "Application Program Interfaces" that has examples.
Chesca
Veteran Member
Posts: 490
New Poster
Congrats on posting!
4/2/2012 12:38 AM
Split
Yes I do, I downloaded the API doc and I am able to find/retrieve recods.I am able to retrieve the records now. How do I verify I am using the correct API (840/850) Though? :
MOVE LPMST-TEM-EMPLOYEE TO DB-EMPLOYEE.
MOVE 10 TO DB-COMPANY.
MOVE LPMST-TEM-EMPLOYEE-GROUP TO DB-EMPLOYEE-GROUP.
PERFORM 840-FIND-TEMSET1.
IF (TAEEMASTER-FOUND)
DISPLAY "TEM-EMPLOYEE " TEM-EMPLOYEE
DISPLAY " AVAIL HRS: " TEM-AVAIL-HRS-BAL
DISPLAY " MASTR ENTRY " TEM-MASTR-ENTRY
ELSE
DISPLAY "NOT FOUND"
GO TO 400-LPVAC-HRI-TRANSACTION-END.
Woozy
Veteran Member
Posts: 709
New Poster
Congrats on posting!
4/11/2012 6:08 PM
Split
It just depends what type of fetch you are wanting to do.
If you know
all
the index keys and are looking for a single record that matches that key then you use 840-FIND-{Index}
.
If you have a partial key and you want to move up/down through the records starting with that key, then you would use 850-FIND-NLT-{Index}
and 860-FIND-NEXT-{Index}
and/or 870-FIND-PREV-{Index}
.
I hope this helps.
Kelly
Chesca
Veteran Member
Posts: 490
New Poster
Congrats on posting!
4/30/2012 4:16 PM
Split
Thank you all.
Please
login
to post a reply.