Re: [GENERAL] how to insert from sequence

1999-10-27 Thread Alain TESIO
> Hi all, > > I need help in inserting a value from sequence. My > code goes like this (from Java). I do face a syntax > level problem. > > statement.execute("insert into T_name (id) values (" + > nextval('s_name') + ")"); > > Thanks in advance for the help. nextval is a sql function, not ja

Re: [GENERAL] how to insert from sequence

1999-10-27 Thread Shadkam Islam
Try statement.execute("insert into T_name (id) values (nextval('s_name'))"); Regards, Shad. On Wed, 27 Oct 1999, soundar rajan wrote: > Hi all, > > I need help in inserting a value from sequence. My > code goes like this (from Java). I do face a syntax > level problem. > > statement.exec

[GENERAL] how to insert from sequence

1999-10-27 Thread soundar rajan
Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') + ")"); Thanks in advance for the help. __ D

[GENERAL] how to insert from sequence

1999-10-27 Thread soundar rajan
Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') + ")"); Thanks in advance for the help. __ D