helpphpGroupWare - 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

Submitted by:  Sigurd Nes <sigurdne>
Submitted on:  Mon 11 Feb 2002 10:36:47 AM UTC  
Category:  Feature Request Priority:  5 - Normal
Severity:  2 - Minor Status:  None
Privacy:  Public Assigned to:  Michael L. Dean <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>In charge of this item.
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>
Project 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>In charge of this item.
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>
Project 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>
Project Member


No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.




Follows 1 latest change.

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

Back to the top

Powered by Savane 3.3