dbdef unique I-D

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

Comments

Legacy Contributor

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).

Copyright © 2025 Infor. All rights reserved.