Re: Cloudscape: AUTOINCREMENT and ERROR 42X01

From: J K via JavaKB.com (forum_at_JavaKB.com)
Date: 12/08/04

  • Next message: satish Tiyyagura via JavaKB.com: "Problems facing in hibernate" 
    Date: Wed, 08 Dec 2004 05:31:22 GMT

    Try this:

    ij> CREATE TABLE customer (number INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1), name VARCHAR(20));

    0 rows inserted/updated/deleted

    ij> INSERT INTO customer (name) VALUES ('Smith Jane');

    1 row inserted/updated/deleted

    ij> INSERT INTO customer VALUES (DEFAULT, 'Jones Tim');

    1 row inserted/updated/deleted

    ij> SELECT * FROM customer;

    NUMBER |NAME
    --------------------------------
    0 |Smith Jane
    1 |Jones Tim

    2 rows selected
    ij>

    jk. 

    -- 
Message posted via http://www.javakb.com
  • Next message: satish Tiyyagura via JavaKB.com: "Problems facing in hibernate"

    Relevant Pages

    • Re: Responsibility
      ... > Lots of good points and avenues to persue from Tim. ... it up to customer ignorance, ... > tint to come close to the proof to keep it 4 color. ... Indeed, you're lucky. ...
      (comp.publish.prepress)
    • Re: An Abstraction Too Far??
      ... OK Thanks Tim I think that I get it. ... In your example it appears that Customer is ... In this case the load method is used to populate the Customer class, ... data access objects separate from my business objects, ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: How to write an IF statement in VBA
      ... suggestion of a Select Case was what I needed. ... Tim is suggesting that if this is the case it is ... you would normally have a company lookup table ... Then, the customer table would ...
      (microsoft.public.access.modulesdaovba)
    • Re: Teaching english in Europe with no degree but TEFL certificate?
      ... >Tim C. writes: ... Ime, the customer ... >translations through translation software with pencil and paper? ...
      (rec.travel.europe)
    • Re: Compensation for cancelled journey
      ... On Sat, 17 Sep 2005, tim wrote: ... > What a lot of twaddle. ... > complain to the authorities that Mr Malone ripped me off because he ... trader who's had problems with a particular customer to refuse to do ...
      (uk.railway)