Hi,

>You can define Dafault-values on a domain level, but these can be
>overridden (is this correct english?) by the user. Defaults work only as
>long as a NULL is left in the fields at posting time.

No they don't -- defaults only work when the field isn't posted at all.
If you supply a NULL, it will (try to) insert a NULL.

>Triggers are working server-side and start to work when the user did
>stop, so the server has full control over the record before physically
>writing it.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com




I do not directly define the fields manually, but have a small tool,
which will generate the alter-table DDL and the trigger-ddl
automatically for me using IB_Script from Jason Wharton's IBObjects and
macro's.

Nick Josipovic

BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618

nick.josipovic@...

> I am no sure if I understand this well - my question is : can be in FB
> somewhere defined what fields are generated for every new table (like
> SYS$CHANGED_BY) or do you define these fields manualy for each table?

I

> have
> similar fields in my tables too and it would by great not to bother

every

> time with the same definition.
>
> Ales Kahanek
>

Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]