Subject | USING TwwIBOTable |
---|---|
Author | Ed Malloy |
Post date | 2001-07-09T20:23:09Z |
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
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