[Phpgroupware-tracker] [ 100417 ] Stored procedures for ID Generation

[nobody]

Support Request #100417, was updated on Mon 02/11/02 at 10:36
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100417&group_id=509

Category: Feature Request
Status: Open
Priority: 5
Summary: Stored procedures for ID Generation

By: sigurdne
Date: Thu 03/27/03 at 13:06
Logged In: YES 
user_id=5071
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; www.ASPSimply.com; 
.NET CLR 1.0.3705)

My problem is that some tables are maintained by an 
external system - and when trying to insert an ID to a 
table (example 'phpgw_addressbook') I get into problems due 
to the auto-incrementing ID.  A common problem (I believe) 
to RDBMS other than MySql - and I really want to keep the 
ID from the other system. I think it should be preferable 
to use a function to insert the next ID for tables of this 
importance.

----------------------------------------------------------------------

By: mdean
Date: Thu 03/27/03 at 05:34
Logged In: YES 
user_id=2484
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4a) Gecko/20030311

I don't see the value in this.  Is there a particular
scenario where you would find it more useful than an
identity field?

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100417&group_id=509