Check out the SERIAL type eg CREATE TABLE OrgUser (orguserid INT NOT NULL DEFAULT SERIAL(1) PRIMARY KEY, orgid...
I think this is what you are looking for.
| H <[EMAIL PROTECTED]>
04/30/2004 01:01 PM
|
To: [EMAIL PROTECTED] cc: Subject: Autoincrement field syntax in MAXDB |
I have the 2 questions pertaining to autoincrement fields.
1) MySql has an autoincrement field type but MAXDB seems not to? Is this true? I kinda thought that MySql and MaxDB had the same code-ancestry so why don't we have that feature in MAXDB?
2) If question 1 is true is the only way to get the autoincrement functionality in MaxDB is via a trigger and an sequence object... If this is true could someone please supply a simple working example. I used to code like this in Oracle but have long ago forgotten the syntax. I looked on the archive and found a thead of this discussion pasted below but the thread NEVER showed a working example.
Thanks in advance,
<<< Start of thread pertaining to Autoincrement field>>
Scott, Niall wrote:
> Hi
>
> I need to create a autoincrement field but I can't use a fixed data type
for reasons I won't go into.
> I need the field to be type integer.
> I thought that I would create a sequence then call it in a trigger thus
>
> Create table test1(
> teid integer,
> aValue Char(10)
> )
> --
> create sequence test1seq increment by 1 start with 1
> --
> CREATE TRIGGER test1_update FOR test1 AFTER INSERT EXECUTE (
> UPDATE dbasys.test1 set teid=test1seq.Nextval;
> )
> --
>
> I tried various trigger code but the above was the only one that didn't
give errors
>
> I then used
> Insert into test1 (aValue) VALUES('Test 1')
> but all I get is a null value in teid.
>
> I have come to SAP DB from Interbase where the trigger code would be
> CREATE TRIGGER test1_update FOR TEST1
> ACTIVE BEFORE INSERT POSITION 0
> AS
> BEGIN
> new.teid=GEN_ID(test1seq,1);
> END
>
>
> But I can't figure out how to do the same in SAPDB
>
> Cheers
---------------------------------
Post your free ad now! Yahoo! Canada Personals
