Subject Re: [IBO] This could be a bug in IBO.
Author Don Gollahon
I just noticed the Insert Sql where I mentioned the "*)" as being the wrong
ending for the comment, is actually only the "*" part of that. The closed
parenthesis ")" is a correct part of the statement.

The corrected statements are:

UPDATE EXCLUDEINFO SET
DAY_ID =:DAY_ID, /*PK*/
ID =:ID, /*PK*/
SRVC_TIME =:SRVC_TIME /*PK*/
WHERE
DAY_ID = :OLD_DAY_ID AND
ID = :OLD_ID AND
SRVC_TIME = :OLD_SRVC_TIME

And here is the InsertSql :

INSERT INTO EXCLUDEINFO(
DAY_ID, /*PK*/
ID, /*PK*/
SRVC_TIME /*PK*/)
VALUES (
:DAY_ID,
:ID,
:SRVC_TIME)



""Don Gollahon"" <dlgllhn@...> wrote in message
news:9ubugi$8ub$1@......
> In the update sql, notice line 4, it has a "," where it shouldn't and ends
> without a closed comment.
>
> In the insert sql notice the "," there too and it ends the comment with a
*)
> instead of a */.
>
>
> "Helen Borrie" <helebor@...> wrote in message
> news:4.2.0.58.20011202104516.015f7900@......
> > At 02:29 PM 01-12-01 -0600, you wrote:
> > >I just tried it and it still creates them wrong. Here's a sample of
the
> > >EditSql that it made.
> >
> > Don,
> > What is wrong with it?
> >
> > Helen
> >
> >