Hi,
Why don't you use the much simpler "insert into frm_sequences(name, value)
values('teste', 123)" like other users? Your example does not work in
PostgreSQL, SQLite, HSQLDB. It works in Apache Derby and MySQL. Test
case: create table test(id int); insert into test(test.id) values(1);
Regards,
Thomas
On Monday, August 20, 2012, Jardel Palagi wrote:
> -- create table
>
> create table frm_sequences
> (
> name varchar(80) not null,
> value int not null
> )
>
> insert into frm_sequences ( frm_sequences.name, frm_sequences.value )
> values( 'teste', 123 );
>
> exhibited this message.
>
> Column "FRM_SEQUENCES" not found; SQL statement:
> insert into frm_sequences ( frm_sequences.name, frm_sequences.value )
> values( 'teste', 123 ) [42122-167] 42S22/42122 (Help)
>
> In other SGBDs, as Mysql. this procedure work!!!
>
> If exist some parameter to activate this option, help me!
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/PBByjINNaGIJ.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
