Re: how to know the next serial id

But, in a multi-user system you wouldn't know if you or someone else would get the 'next' serial id. And, even if a row is deleted the serial won't be reused. "vk02720" <vk02720@my-deja.com> wrote in message news:4d814faa.0407171501.21e44082@posting.google.com... > How do I know the next value that is going to be in a serial id column > before I do an insert ? select max(my_id) may not work because the > rows get constantly deleted as well. > Is there any way in dbaccess to view the next id as well ? > > TIA