Re: I'm going crazy - Sequence, insert problem

From: Karsten Farell <kfarrell_at_medimpact.com>
Date: Wed, 09 Oct 2002 19:54:23 GMT
Message-ID: <PP%o9.1738$4D6.133260522@newssvr21.news.prodigy.com>

steve deno wrote:
> INSERT INTO source.desctable
> (het_source_food_id,
> description,
> desc_2,
> f_name,
> prep_type,
> brand_id,
> category_id,
> serving_desc,
> portion_id,
> gram_weight,
> date_created,
> date_modified,
> modified_by,
> created_by )
> VALUES
> (a,
> '1',
> 'sss',
> 'sss',
> '1',
> 1,
> 1,
> '1',
> 1,
> 2,
> sysdate,
> sysdate,
> user,
> user );

Try

INSERT INTO source.het_source_foods (...) VALUES (source.het_source_food_id_seq.nextval,...); Received on Wed Oct 09 2002 - 14:54:23 CDT