Create your IDO before you set up primary/foreign keys on your new table.

This was a strange one that I had to go to Infor Support to resolve. I used the SQL Tables Form to set up a brand new table, generated a new primary key, built the IDO, and then created a form bound to the IDO.

(Yes, I probably could have done it much faster with the New Data Maintenance wizard, but old habits die hard.)

What was weird was that every time that I tried to save data using this form, I got everyone’s favorite error: “Object Reference Not Set To Instance of Object” I took it to Infor, and they told me to delete the IDO, delete the key constraints, recreate the IDO, then add the key constraints back in. Sure enough, that solved the problem. Infor seems to know this is an issue, but I haven’t found a KB on it yet. Hopefully the incident I have in will become a KB.

One thought on “Create your IDO before you set up primary/foreign keys on your new table.

Leave a reply to Jeff Steward Cancel reply