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

 
 

You are not allowed to post comments on this tracker with your current authentification 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 RequestPriority: 5 - Normal
Severity: 2 - MinorStatus: None
Privacy: PublicAssigned to: Michael L. Dean <mdean>
Open/Closed: OpenOperating 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
importance.

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
it

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 ?

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

Regards

Sigurd

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 18 Sep 2002 12:41:09 AM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup