Ted, I'd guess that AUTONUM counts as changing the structure of your database which is forbidden from an EEP.
Alternatively, if you have an Owner password set up you need to have that permission to change an autonumber. Regards, Alastair. ----- Original Message ----- From: Ted Lienhard To: RBASE-L Mailing List Sent: Friday, February 15, 2008 10:51 PM Subject: [RBASE-L] - Using AUTONUM in an EEP I have a form that has a button to delete rows from a table. This leaves a number missing in the sequential RNUM column that I would like to fix by renumbering using AUTONUM. When I include the AUTONUM command in the EEP, I get this error: "Autonum aborted, resource unavailable." My syntax works fine from the R> prompt. I have tried a CLOSEWINDOW to avoid any possibility of having the table already in use, but that does not stop the error. Syntax used: autonum RNUM in journal using 1 1 num Version: 7.6.3.30214 Any ideas would be appreciated! Best Regards, Ted Ted Lienhard CNE NCT Golden Valley Consulting ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1282 - Release Date: 15/02/2008 19:08
