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
importance.

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
it

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 ?

eksample:
http://www.objectmatter.com/vbsf/docs/maptool/idgen.htm
l#UUIDExample

Regards

Sigurd

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-d3ae.
Corresponding source code