Print Thread
Generated QBE is wrong
#7519 06/20/05 12:12 PM
Joined: Jan 2004
Posts: 59
G
giga Offline OP
Member
OP Offline
Member
G
Joined: Jan 2004
Posts: 59
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:
Code
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:
Code
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

Re: Generated QBE is wrong
#7520 06/20/05 07:57 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
This is indeed not correct. We'll fix it.

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


Marco Kalter
Allround Automations
Re: Generated QBE is wrong
#7521 06/21/05 11:36 AM
Joined: Jan 2004
Posts: 59
G
giga Offline OP
Member
OP Offline
Member
G
Joined: Jan 2004
Posts: 59
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.

Re: Generated QBE is wrong
#7522 06/21/05 04:02 PM
Joined: Oct 1999
Posts: 138
Eschborn, Germany
Member
Offline
Member
Joined: Oct 1999
Posts: 138
Eschborn, Germany
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

Re: Generated QBE is wrong
#7523 06/21/05 06:56 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
We don't have a date for 4.0.7 yet.


Marco Kalter
Allround Automations
Re: Generated QBE is wrong
#7524 07/07/05 12:34 PM
Joined: Jan 2004
Posts: 59
G
giga Offline OP
Member
OP Offline
Member
G
Joined: Jan 2004
Posts: 59
Hi Marco!

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

Greetings and thanks
Vlada


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.083s Queries: 13 (0.013s) Memory: 2.5154 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-28 18:24:33 UTC
Valid HTML 5 and Valid CSS