Subject Re[2]: [firebird-support] Default value
Author Helen Borrie
At 07:25 PM 27/02/2004 +0300, you wrote:
>Dear Lucas,
>
>Friday, February 27, 2004, 7:00:52 PM, you wrote:
>
> >> Well... ok, yes! I'm talking about FIBPlus :))
>
>LF> Yes, but if this is not just speeding up the connection, isn't it?
>FIBPlus has a cache for metadata if you need. So, this even does not
>reduce applications performance on low-speed channels.
>
>LF> In IBO for example you can define default values within the Connection
>LF> level.
>This is not bad, but why should I define the default values in my
>application, if they are already defined in a database? :).

The answer to that question is - on a slow connection, why add an extra query?

Luckily, both IBO and FIBPlus seem to give you both options. If you want
to assign the defaults in the app, in IBO you define them once, at
Connection level -- then all queries use them. TQuery only gives you the
option to define a default for a TField object, which can be agonising.

/heLen