Using a Business Object to insert a new row

There appears to be a previous discussion on this topic, but the attached solution files won't open on my computer.

I am trying to using a table business object in an administrative form to enter a new row in the underlying table. The primary key for the table is an int. When the form loads, I set the field for the primary key to the next highest integer. However when I submit the form it just updates the primary key of the first record. What is the standard way of using a business object to insert new rows into a table?

Thanks,

Mark

Find more posts tagged with

BPM

Comments

achopra

Mark,

Have you considered using a table BO and an editable grid on your Admin form to insert/update rows into the underlying table? This is pretty quick to setup and works well for basic table data maintenance. I usually set the primary key database column to be an identity field as well, so that the database handles auto-incrementing the value when a new row is added.

Mark Kurt

Thanks, that works and gets me past my immediate problem, however this table has a lot of fields and would like to give users access to all the fields when they are entering a new record. Form entry will probably be the best method. Is there anyway to handle form entry using a BO or should I do the old 7.6 way of inserting directly to the DB?