G
Guest
I am attempting to get the maximum value from a specific table (select max(id) from transactions) and it seems to work... that is until you do the following
- select the maximu
- insert a new record (meaning the id is increased
- select the maximum again
When done through an oledb transaction the first and last selects return the same value, when they should clearly not
I am connecting to an Oracle 8i DB, and using SQL plus doing the same thing (select, insert, select, commit/rollback) it will give the correct answers
Is there an easy way to get around this problem
Cheer
Martin
- select the maximu
- insert a new record (meaning the id is increased
- select the maximum again
When done through an oledb transaction the first and last selects return the same value, when they should clearly not
I am connecting to an Oracle 8i DB, and using SQL plus doing the same thing (select, insert, select, commit/rollback) it will give the correct answers
Is there an easy way to get around this problem
Cheer
Martin