• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

L_HAPI.L_INDEX creation logic

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Travis
New Member
Posts: 1
New Member
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
Basic Member
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.