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 Feb 11 10:36:47 2002  
Category: Feature RequestPriority: 5 - Normal
Severity: 2 - MinorStatus: None
Privacy: PublicAssigned to: Michael L. Dean <mdean>
Open/Closed: OpenOperating System: None

Thu Mar 27 13:58:06 2003, 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 Mar 27 13:06:39 2003, 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 Mar 27 05:34:36 2003, 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 Feb 11 19:44:34 2002, comment #1:

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

Dan Kuykendall <seek3r>
Project Administrator
Mon Feb 11 10:36:47 2002, 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 click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.


Please enter the title of George Orwell's famous dystopian book (it's a date):



Follows 1 latest change.

Date Changed By Updated Field Previous Value => Replaced By
Wed Sep 18 00:41:09 2002skwashdAssigned toNone=>NA

Back to the top

Powered by Savane 3.1-cleanup1