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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211595 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
