Generated QBE is wrong

[giga]

Hi, can you help me? I have oracle dataset and perform QBE.

This values are entered into fields:

CRCO: in ('*', 'B')
LM_LSTART: not 'LK*' and 'EP*'

Generated QBE:

SELECT *
  FROM l_lety_main
 WHERE NOT (UPPER (LM_LSTART) LIKE 'LK%' OR UPPER (LM_LSTART) LIKE 'EP%')
    OR UPPER (LM_LSTART) IS NULL AND (UPPER (LM_CRCO) IN ('*', 'B'))

Problem is OR UPPER (LM_LSTART) IS NULL because, there is not parenthesis.

Correct SQL must be like:

SELECT *
  FROM l_lety_main
 WHERE (   NOT (UPPER (LM_LSTART) LIKE 'LK%' OR UPPER (LM_LSTART) LIKE 'EP%')
        OR UPPER (LM_LSTART) IS NULL
       )
   AND (UPPER (LM_CRCO) IN ('*', 'B'))

Sorry my poor English.

DOA 4.0.6.2
DELPHI 6.0

 

[Marco Kalter]

This is indeed not correct. We'll fix it.

If you need a pre-release, let me know.

 

[giga]

Hi Marco,

thanks for your answer. Yes I need pre-release, because on another way I must write my own QBE SQL builder.

Can you tell me, is another way to test char "*" if "Allow file Widcards" is checked? Char "*" is not converted to "%" only during use of "in('*')" operator, I think.

Thanks for your support.

 

[Jens Fudickar]

Hi Marco,

any chance of a public pre release?

Or will there be a new version in the near future? I think you suggested it the last time for april.

Greetings and thanks
Jens

 

[Marco Kalter]

We don't have a date for 4.0.7 yet.

 

[giga]

Hi Marco!

Can you tell me, when will be pre-release with this bug fixed?

Greetings and thanks
Vlada