At 07/09/2001 05:23 PM, you wrote:

>Hi all,
>
>I am trying to use a TwwIBOTable to append a record to a table called
>"CARS." While the database is IB 6.x, it dates back to 5.x where a
>column called "YEAR" was legal; and I don't know how to drop this column
>(Alter table ... does not work, since YEAR is a reserved word now).

To drop the column, reference the column as "YEAR" (i.e. ALTER TABLE
YOUR_TABLE DROP "YEAR")

Hope this helps.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)