> > I want to enter new record into this table so I tried all of the
> > below:
> > insert into obiekty; <- that would be particulary nice
> Insert what?

nothing, just insert, had the server tried, it would find out that
the field is filled by the trigger, and all constraints are
fullfilled

>
> > the statement
> > insert into obiekty (id) values(null);
> > worked, but on all other occassion I could skip the ID column
> >
> > what is suggested by SQL92 - can I ommit autoincremented fields

in

> > queries?
>
> There's no auto-increment field. Firebird doesn't support auto-

increment

> fields. What you have is a _pseudo_ auto-increment field.

yes, I know that

>
> You can ommit any fields that:
> - are defined as NULLable
> - get filled by triggers

I understand that you mean 'or' between this options
which in this case is completed, I have the field that is filled by
a trigger

If you didn't mean 'or' than I do not agree
Had I added another_varchar_field to this table (leaving the not
null attribute with ID field), I could use:
insert into obiekty (another_varchar_field) values('anything');
and firebird would happily proceed, allowing me to omit pseudo_auto-
incremented id field

but that was just a fun case I was wondering over (I should be
leaving the office hour ago)

Have a nice day everyone

>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com

CUIN Kaczy