I am using the following SQL:

    alter table MaxxMEAD add StartingDate Date;

and it works fine. But if I change it to:

    alter table MaxxMEAD add StartingDate DateTime;

an exception occurs stating "Capability not supported". Is there a way to
alter a table and add date/time?

Thanks
Ed Dressel

I'm not sure, but isn't a Paradox datetime field type called "timestamp",
not "datetime"?  That's what I see in Database Desktop, anyway.
-Howard

Use TimeStamp for the field type, not DateTime. You will find the types that
Local SQL accepts in the Local SQL help file if you search for ALTER TABLE.

--
Bill

Did not know it existed. Thank you!

Ed Dressel