Alter table, how to setup default field values?

MLumbrer

Delphi Developer

Mon, 14 Jun 2004 04:26:47 GMT

Alter table, how to setup default field values?

Hi,
I'm using Paradox7, and by using the sentence:

'ALTER TABLE "myTable" ADD AStringField CHAR(100)'

I can add a field of type char named AStringField to myTable

How can I specify the default value of the field?
I mean, by using the Database Desktop you can assign a default
value to be assigned automatically to a field after an append.
But I can't figure out how do that with ALTER TABLE.

Regards
Mauricio

Team

Delphi Developer

Mon, 14 Jun 2004 03:39:46 GMT

Re:Alter table, how to setup default field values?

You cannot do that with SQL. The only way to set the default value is with
BDE API functions.

--
Bill
(TeamB cannot answer questions received via email)

MLumbre

Delphi Developer

Mon, 14 Jun 2004 05:53:34 GMT

Re:Alter table, how to setup default field values?

Quote

> You cannot do that with SQL. The only way to set the default value is with
> BDE API functions.

Hi,
the only solution is the 'cumbersome' dbiDoRestructure function?
regards
Mauricio

Other Threads

1. Alter field to Default value

2. Setting Default Field Values when Building a Table on the Fly

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

4. Retrieving default field values from MSSQL table via BDE

5. Retrieving default field values from MSSQL table

6. how to create table with field's default value

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

8. Default Field Values When Creating Tables In Code

9. ALTER TABLE: adding DEFAULT and NOT NULL

10. How to update fields of a table without commit between every ALTER TABLE