Column value - Thick Client Oracle 2-tier protocol
I am working on a Oracle 2-tier protocol on a CRM desktop application.
Recorded scenario has a insert statement for which a record will be inserted into the table (say Table Name: Customers). For every run the customer id value is incremented by 1
I need to get the Current maximum Customer Id column value from the table and increment by 1 pass into the insert statement.
Re: Column value - Thick Client Oracle 2-tier protocol
This sounds strange to me aren't id columns usually set to auto-increment? so that you'd insert everything but the id field and the id field is set by the db as it executes the insert.
if the app has to get the actual previous max_id isn't there always a chance that a second user could also get the same max_id and try to insert a record at virtually the same time leading to problems with referential integrity