On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > > > On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > > > How many times would it really matter if it did? I have seen sometimes > > > where > > > a "new app" would start off at say ID value of 143 just because of all > > the > > > testing and not resetting the sequence never seemed to be an issue > > though. > > > > > > I suppose if the seq value has some real meaning, yo umight need to fuss > > around with a way to ensure things are 'in sequence' so to speak. > > Typically > > I could care less, the sequence is usually a PK and has no real meaning > to > > the end user/gui. IIRC, there is no guarantee a numerical sequence in > > Oracle > > is always one apart. You could get 1,2,3,4,10,11,20. That is what I've > > been > > told at least. > > > When I have noticed this happening it usually ended up the trigger was > setup > with some caching. That is not to say it may or does happen in other > situations. I too could really care less what the ID value is, not sure > how > many people out there really would care since never ran into a customer > who > did but I am sure there are many out there that do. > > > > If your SQL has only one insert, why use a transaction? Vacuously its > > considered a transaction I suppose. Further, if a single SQL fails in > CF, > > a > > commit is never issued for it. I have always understood transactions to > be > > a > > group of SQL statements that you want to execute in concert. > > > I was referring to a single insert statement followed by a single select > statement to grad the ID of that inserted record, not just one insert and > nothing more.
ok. as I mentioned earlier in the this thread, a rollback does not effect a sequence. So wrapping a transaction around these too queries is no different really then wrapping it around the single insert. DK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54