mainphpGroupWare - Support: sr #100417, Stored procedures for ID Generation


You are not allowed to post comments on this tracker with your current authentication level.

sr #100417: Stored procedures for ID Generation

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Mon 11 Feb 2002 10:36:47 AM UTC
Category:  Feature Request Priority:  5 - Normal
Severity:  2 - Minor Status:  None
Privacy:  Public Assigned to:  mdean
Open/Closed:  Open Operating System:  None

Thu 27 Mar 2003 01:58:06 PM UTC, comment #4: 

If you want to keep the original ID, won't set
identity_insert off work?

Michael L. Dean <mdean>
Thu 27 Mar 2003 01:06:39 PM UTC, comment #3: 

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

Sigurd Nes <sigurdne>
Group Member
Thu 27 Mar 2003 05:34:36 AM UTC, comment #2: 

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

Michael L. Dean <mdean>
Mon 11 Feb 2002 07:44:34 PM UTC, comment #1: 

This is a good idea. I will ask mdean what he thinks about

Dan Kuykendall <seek3r>
Group administrator
Mon 11 Feb 2002 10:36:47 AM UTC, original submission:  

Would it be an idea to use stored procedures for ID
generation for MSSQL instead of autonumber ?




Sigurd Nes <sigurdne>
Group Member


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.


Follows 1 latest change.

Date Changed by Updated Field Previous Value => Replaced by
2002-09-18 skwashd Assigned toNone None

Back to the top

Powered by Savane 3.13-4448.
Corresponding source code