Hi,

On Wed, 17 Nov 2004 15:10:55 -0000, rick_roen <rick@...>
wrote:

>
> Delphi 7, FB 1.5
>
> Using TIBDataSet component
>
> I have a form used for editing/inserting new customers.
>
> When the user wants to add a new customer, I am starting with:
>
> IBDataSet.Append;
>
> which clears all the DBEdit components.
>
> I want to fill-in the default values for things like Terms, BillTo
> number etc. which are set in the fields on the Customer. For
> example, Terms field should default to 2.
>
> How do I get these default values? I know which fields have default
> values, I just don't know how to get them from the database.
>
> I suppose I could write a procedure to insert a new blank record,
> read the default values, rollback, then return the defaults, but I'm
> not sure if there is a more elegant (or easier) way to do this.

As far as I know Delphi BDE and IBX components does not get any info from
DB Server (FB/IB or anything else) about default value of field.

Cheers,
--
Miroslav Penchev