Tony wrote: > does that retrieve the newest UUID Primary Key generated? > right now, i have a dateAdded field that i sort by, to get the newest one.
That's not real reliable. What happens if two records are added in the same second? :) Yes, it returns the last identity inserted, and inside a transaction, I think it's reliable. I recalll the old days of having a separate field that I would throw a UUID into then query it out to get the autonumber. *shudder* I haven't done that in yearS! Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236862 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
