Alter table SQL for Paradox tables

Ed Dressel

Delphi Developer

Sat, 08 Feb 2003 03:00:00 GMT

Alter table SQL for Paradox tables

I am trying the following SQL:

Alter table MyTable Add NewColumn boolean default False;

But it does not work. There are default values for paradox fields, is there
a way to set it?

Thanks
Ed Dressel

Ed Dresse

Delphi Developer

Sat, 08 Feb 2003 03:00:00 GMT

Re:Alter table SQL for Paradox tables

I should qualify. If I drop the 'default False', it works fine. But I want
the default to be false.

Thanks
Ed Dressel

Brian Bushay Tea

Delphi Developer

Sun, 09 Feb 2003 03:00:00 GMT

Re:Alter table SQL for Paradox tables

Quote

>But it does not work. There are default values for paradox fields, is there
>a way to set it?

You will have to use the BDE API method dbiDoRestructure
http://www.borland.com/devsupport/bde/bdeapiex/dbidorestructure.html
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Using Alter Table To Restructure Paradox Tables

2. SQL Paradox: ALTER TABLE

3. Alter paradox table via SQL

4. CREATE TABLE vs CREATE TABLE + ALTER TABLE

5. ALTER TABLE/ALTER COLUMN problem with MS Access 2K

6. IB6.0 Bug? ALTER TABLE ALTER Fieldname

7. joining a paradox table to an MSAccess table in an SQL query

8. Corrupted tables using SQL functions with Paradox tables and BDE 5.01

9. Q: Converting Paradox table to MS SQL table

10. PARADOX SQL - Update master-table from Detail-table