Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
L_HAPI.L_INDEX creation logic
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5161
People Online:
Visitors:
265
Members:
0
Total:
265
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Financials
L_HAPI.L_INDEX creation logic
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Travis
New Member
Posts: 1
10/14/2010 3:31 PM
HI,
I work for an EPP solutions company and my client is using Lawson 8.3 database. I am working on an interface that stores invoice image URLs. They are linked using the L_INDEX column to our system.
From my understanding, Lawson starts with the L_INDEX of ZZZZ and goes down alphabetically. My questions is, what would happen if an L_INDEXes existed that started with YZZZ - YAAA? Would Lawson keep going down until it found an un-used index or would it replace the index that is already there?
Thanks in advanced.
Travis
Angela Collins
Basic Member
Posts: 20
4/15/2011 8:13 PM
I found out the answer the hard way. When I was new to Lawson having switched from PeopleSoft in 2004, our database was set up wrong with the wrong codeset and collating sequence. Instead of the sequence being 0-9, A-Z, and then a-z, it was set up as 0-9, Aa, Bb, ..., - Zz. The result was that it tried to insert duplicates. When there was a duplicate, it tried the next number until it found an open l_index value. The result was that the program inserting comments was running a very long time. I opened a case with Lawson back in 2004. I ended up with someone with a lot of knowledge about comments. I haven't purged the information from memory as much as I tried.
You are not authorized to post a reply.