Hi,
I've created a temp-table htempxmlcolumns containing 4 fields:
username, database, table, fields.
Then I do some logic and I fire this statement:
IF htempxmlcolumns:HAS-RECORDS THEN
hbufxmlcolumns:FIND-UNIQUE(SUBSTITUTE("where username = &1 and database = &2 and table = &3",QUOTER(huser:SCREEN-VALUE),QUOTER(cdata),QUOTER(ctable))).
I get the
** Unable to understand after -- "username = admin AND". (247)
** Cannot understand expression involving AND operator. (249)
When I do a
MESSAGE SUBSTITUTE("where username = &1 and database = &2 and table = &3",QUOTER(huser:SCREEN-VALUE),QUOTER(cdata),QUOTER(ctable)).
I get:
where username = "admin" and database = "exactopenedge10" and table = "admdat"
So no problem there... Can anyone explain? I tried using QUOTER on the cdata/ctable and all sorts of things.
Funny: if I lose the substitute and just do
hbufxmlcolumns:FIND-UNIQUE("where username = 'admin' and database = exactopenedge10 and table = 'admdat'").
I get the same message.
I've created a temp-table htempxmlcolumns containing 4 fields:
username, database, table, fields.
Then I do some logic and I fire this statement:
IF htempxmlcolumns:HAS-RECORDS THEN
hbufxmlcolumns:FIND-UNIQUE(SUBSTITUTE("where username = &1 and database = &2 and table = &3",QUOTER(huser:SCREEN-VALUE),QUOTER(cdata),QUOTER(ctable))).
I get the
** Unable to understand after -- "username = admin AND". (247)
** Cannot understand expression involving AND operator. (249)
When I do a
MESSAGE SUBSTITUTE("where username = &1 and database = &2 and table = &3",QUOTER(huser:SCREEN-VALUE),QUOTER(cdata),QUOTER(ctable)).
I get:
where username = "admin" and database = "exactopenedge10" and table = "admdat"
So no problem there... Can anyone explain? I tried using QUOTER on the cdata/ctable and all sorts of things.
Funny: if I lose the substitute and just do
hbufxmlcolumns:FIND-UNIQUE("where username = 'admin' and database = exactopenedge10 and table = 'admdat'").
I get the same message.