infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Technology Customer Community [READ ONLY]
dbdef unique I-D
jacob-jellison
I created a custom table using dbdef and set unique-ID = yes. It created the table but after quick painting a screen I noticed that the code is not doing anything to populate a unique value in the field. How are we suppose to get a unique value into the database field? a KB article sort of mentioned that the database driver (Oracle) would handle the creation of the unique id?
I'm hoping to have the same functionality as in the GLTRANS table where every single record inserted gets assigned a OBJ-ID.
THanks.
Find more posts tagged with
Infor Lawson Technology Group - Discussion
Comments
unknown
Hi awolff01,
When you created the table, it should have created the "Unique I D" column automatically. Did that happen?
Did you attempt to add a record via your quick-paint form to see if it does auto-populate? If the "Unique I D" column is an identity column (I think it is), then it probably manages the incrementing and populating on the DB side rather than via the form.
jacob-jellison
Kelly, Yes it did create the unique id column and I could see it via oracle.
I was able to load a record into that table by using importdb and explicitly entering a '1' for the unique-id field. But after quick painting the table I tried to add another record and received the attached rude message...ie 'non hex digit'
productmodeling
Unique ID & Object ID are not the same. Unique_ID columns are auto-populated by the DB interface (oradb11, msf2000, etc) when a row is inserted. If you are looking for functionality that links related data together, similar to how Lawson systems link their transactions back GL (GLTRANS), then you will want to use the OBJID table & column type. You will need to create a new OBJ_TYPE in the OBJID table that will store the last OBJ_ID value. I don't know if there is a standard online form for that. I usually generate a quick paint to use. In your custom program, you will invoke IFOB.1 to increment the next OBJ_ID value to store on your custom table(s).
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions