Hi all ,i have a simple WF code.when i try to get the Sql trace out of it,i am missing the SQL stmt for one WF line,the line is "WHERE TABLENAME NOT LIKE '%_WRK' OR '%_BKP' OR '%_DMY' OR '%_TBX' OR '%_ARC' OR '%_PER' ".(where TABLENAME is field)

can some one tell me please on why i am not getting the sql generated for only the above where statement of WebFocus,is something wrong with that where stmt?

please reply...

This message has been edited. Last edited by: Kerry,

Swati - It would be easier to review if you could post the actual FOCUS code and the SQL being generated. Can you please?

Sandeep Mamidenna

Unfortunately, the SQL translator does not like LIKE.

In a case like this I would use SQL passthru and code my own SQL.

but there are other where stmts in code with like operator but why only the above stmt cannot get sql.

Because the mask is at the beginning of the string and not at the end.

got it ,Thx francis.

I think that this would have been highlighted in the SQL trace with a (FOC2598) FOCUS IF/WHERE TEST CANNOT BE PASSED TO SQL

Definitely Waz, except that the "why" is not documented anywhere:

quote:

Because the mask is at the beginning of the string and not at the end

Well a case needs to be put in with IBI to make sure the documentation is updated.