Charles,
Try SELECT (MAX(ID) + 1)) ....
Regards
Clive Williams
Sydney Australia
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 2:40 AM
Subject: RE: weird error message
> Hmmm.. I am the only one using this database.
>
> The error occurred when executing an eep:
>
> set v vtid integer
> select (max(id +1)) into vtid from nonhazdetail whe
manifest_id=manifest_id
> autonum id in nonhazdetail delete
> autonum id in nonhazdetail using .vtid
> INSERT....
>
> In the course of tracing and breaking out of my program is it possible
that
> the table became locked?
>
> thanks
>
> -----Original Message-----
> From: Jeff Ward [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 27, 2001 4:29 PM
> To: [EMAIL PROTECTED]
> Subject: Re: weird error message
>
>
> Charles,
>
> Most likely the table is locked so it cannot generate a new
> autonumber. This can happen at one of my clients if someone gets thrown
> out in the middle of a sensitive proceedure.
>
> Hope this helps.
>
> Jeff Ward
>
>
>
> >In RBW 6.5+,
> >What does error "AUTONUM aborted - resource unavailable (380)" indicate?
> >
> >thanks!
> >
> >Charles Sikora
> >Senior Gas Supply Specialist
> >Manlove Field
> >Peoples Energy Corporation
> >
> >----------------------------------------------------------------
> >The information transmitted is intended only for the person
> >or entity to which it is addressed and may contain confidential
> >and/or privileged material. Any review, retransmission,
> >dissemination or other use of, or taking of any action in reliance
> >upon, this information by persons or entities other than the
> >intended recipient is prohibited. If you received this in error,
> >please contact the sender and delete the material from any computer.
>
> ----------------------------------------------------------------
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance
> upon, this information by persons or entities other than the
> intended recipient is prohibited. If you received this in error,
> please contact the sender and delete the material from any computer.
>
>
