Subject USING TwwIBOTable
Author Ed Malloy
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).

When I try and use the TwwIBOTable control, carefully selecting which
field objects to EXCLUDE YEAR, I get the follow error when trying to
post:

ISC ERROR MESSAGE 335544569

dynamic SQL Error
SQL Error Code = -104
Token Unknown - line 6, char 6
YEAR

Statement:
TIB_Statement: ""

Statement:
TIBOInternal Dataset: "carTableIBOqrCarTable"

???

I tried to create and InsSql query for the control, but I received
varying errors about columns not existing, or illegal controls.

Can anyone tell me what's happening? And how do I use this contol?

tia,

ed