Subject This could be a bug in IBO.
Author Don Gollahon
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@...)