rajsubramani wrote:

> 1. Can I create an fdb file (for FB1.5) where DB Owner is other than
> SYSDBA (if yes, is the significant characters restricted to 6).

Yes. AFAIK, it's limited to 8, like any other user.

> 2. Does firebird 1.5 support triggers on columns:
>
> at the moment for table foo:
> CREATE TRIGGER FooTrigger for Foo ACTIVE BEFORE INSERT AS
>
> for column bar on table foo can I say something like:
> CREATE TRIGGER FooTrigger for bar of Foo ACTIVE BEFORE INSERT AS

You better read again what you just wrote.

When you do insert, the whole row is inserted. You can't just insert a
value in one column.

If you just wish to manipulate newly (to be) inserted value, use the new
keyword:

if (new.bar is null) then do something...

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net