Subject | This could be a bug in IBO. |
---|---|
Author | Don Gollahon |
Post date | 2001-12-01T05:44:20Z |
IBO cannot create the update sql statements properly for the following
table. I have to edit them by hand to get them to work.
CREATE TABLE EXCLUDEINFO (
ID INTEGER NOT NULL
, DAY_ID SMALLINT NOT NULL
, SRVC_TIME TIME NOT NULL
, CONSTRAINT EXCLUDEINFO_PRIMARY
PRIMARY KEY ( ID, DAY_ID, SRVC_TIME )
)
In IBO 4.2 Fa, use an IBOQuery, set the Sql to
Select * from ExcludeInfo
then goto the UpdateSql tab and press the "Generate for Table" button.
Editsql and Updatesql statements are improperly created. I haven't had this
happen with any other table.
--
Don Gollahon
(dlgllhn@...)
table. I have to edit them by hand to get them to work.
CREATE TABLE EXCLUDEINFO (
ID INTEGER NOT NULL
, DAY_ID SMALLINT NOT NULL
, SRVC_TIME TIME NOT NULL
, CONSTRAINT EXCLUDEINFO_PRIMARY
PRIMARY KEY ( ID, DAY_ID, SRVC_TIME )
)
In IBO 4.2 Fa, use an IBOQuery, set the Sql to
Select * from ExcludeInfo
then goto the UpdateSql tab and press the "Generate for Table" button.
Editsql and Updatesql statements are improperly created. I haven't had this
happen with any other table.
--
Don Gollahon
(dlgllhn@...)