Subject | Re: [IBO] This could be a bug in IBO. |
---|---|
Author | Don Gollahon |
Post date | 2001-12-02T05:13:31Z |
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@......
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 */.the
>
>
> "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
> > >EditSql that it made.
> >
> > Don,
> > What is wrong with it?
> >
> > Helen
> >
> >