ALTER TABLE

[amerifax]

We are trying to add a field on the fly. This is the code that is shown in the example:

ALTER TABLE CUSTOMER ADD REFER CHAR(20), ADD LASTCALL DATE, DROP FIRST_CONT

The code we are using is:

alter table Perdil add STEPXX char(3)

The error we get is Table does not exist. I tried adding the path to the file which is d:\support\dbf\Perdil.dbf. We also tried using the file first which returned the same error - Table does not exist.

Any help would be greatly appreciated.

Bob

 

[dgrewe]

try alter table Perdil add STEPXX c(3)

David W. Grewe Dave

 

[dgrewe]

I answered before I read all the text your entered

We also tried using the file first which returned the same error - Table does not exist.

When do you get the error on the
USE command
or
ALTER command ??


David W. Grewe Dave

 

[amerifax]

We get the message table does not exist on the alter command. We tried your suggestion plus about 15 variations of it. There is probably something minor we are missing. I also tried different of using and not using the table. We really appreciate your help we have been stuck here for days.

Bob

 

[dgrewe]

Is the table in a database?
Have you opened the Database Exclusive?
Do you have the Table opened exclusive?


David W. Grewe Dave

 

[amerifax]

My mistake. The program was not in the proper directory with the file we were trying to edit. When the file is in the same directory this will work:

close all
alter table car add type char(4)

This created a field called type with 4 characters.

Thanks,

Bob