how to create table with field's default value

forums.inprise.com

Delphi Developer

Sat, 30 Mar 2002 03:00:00 GMT

how to create table with field's default value

can i create a table using TTable.CreateTable, which I want to set some
fields with a default value.

if cannot, how can i set it?

thx for any help
Johanes

Brian Bushay Tea

Delphi Developer

Sat, 30 Mar 2002 03:00:00 GMT

Re:how to create table with field's default value

Quote

>can i create a table using TTable.CreateTable, which I want to set some
>fields with a default value.

To set defaults on Paradox tables you need to use dbiDoRestructure.
there are examples at
http://www.Borland.com/devsupport/bde/bdeapiex/dbidorestructure.html

However you probably will find it a lot easier to set the default expression
property of the ttable's Tfields

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Paon Perspicac

Delphi Developer

Tue, 02 Apr 2002 03:00:00 GMT

Re:how to create table with field's default value

write the default values in the table.AfterIinsert event.

forums.inprise.com <johanes.l...@kreators.com> a crit dans le message :
7ttmd4$s...@forums.borland.com...

Quote

> can i create a table using TTable.CreateTable, which I want to set some
> fields with a default value.

> if cannot, how can i set it?

> thx for any help
> Johanes

Other Threads

1. ADOX and default value of a table's field

2. Creating a paradox table with default value in some fields

3. Default Field Values When Creating Tables In Code

4. Default values on creating fields

5. How to create field (varchar) with value default ?

6. Date fields - Default's values

7. change field's default value dynamically

8. Field's Default value

9. Paradox/Delphi - Defining default value while creating table

10. Default values in Paradox dynamically created tables