Thanks Albert
I use that logic for my button but I did not know if it
was a good practice to do daily or not.
Marc
----- Original Message -----
From: "Albert Berry" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, August 01, 2008 12:16 PM
Subject: [RBASE-L] - Re: Autonum broken
Marc, you can do an autonum update any time at all. You could add the
autonum fixer to the startup routine easily.
SELECT MAX(PK+1) into vPK FROM table
autonum PK in TABLE USING .vPK
Marc wrote:
HI
We have a few users where the Autonum quits working for some reason.
My guess is dirty power or user mistakes.
I have a House keeping form where I have a button that they can click to
reset the Autonum but is there a way to check for this and fix it in a
start
up routine?
Thanks
Marc
