I think there is more to what you stated then Jon Hall mentioned.
Why not lose the autonumber field and do autonumber yourself by incrementing
MAX(id) + 1 and using that as your unique id. This way your related link
from the line items to the order header is something YOU created and can
RECREATE at will. With an autonumber field if you ever lose any data you
cannot create an accurate reproduction as the autonumber field when
regenerated will fill in the gaps and there goes your relationship
accurracy. I recently had a datasource that would not open in Access, but
was still able to be viewed using the odbc driver. I wrote a file that
exported all the fields of all the tables in the datasource and then
imported them into an empty copy of the database. I was able to get it all
back because my indexes were not autonumber.
Just a thought to ponder, as it worked for me.
----- Original Message -----
From: Bud <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 12:26 PM
Subject: Re: cftransaction and Access autonumber
> On 2/17/01, Jon Hall penned:
> >Yup, that is exactly what is happening. Once you insert a new record the
> >autonumber index gets incremented. If you delete that record as happens
in
> >case of an error with cftransaction. The next time a new record is
inserted
> >it just continues on to the next highest number.
>
> I figured that's what it must be. Thanks for the confirmation.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
