Ignore Blank Issue

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
smoady
Posts: 23
Joined: February 4th, 2022, 3:52 pm
Contact:
Contact smoady

Ignore Blank Issue

Unread post by smoady »

When running the inquire, keys are set to ignore blanks as shown in the screenshot below. Query output shows otherwise.

Code: Select all

select  SDDOCO, SDDCTO, SDLITM, SDDSC1, SDUORG, SDSOQS, SDSOBK, CAST(SDUPRC / 10000.00 AS DECIMAL(9,2)) as SDUPRC, SDVR01, SDTRDJ, SDDRQJ, SDPPDJ, SDLNID, SDEUSE, SDKCOO from JDE_Development.TESTDTA.F4211 WHERE  SDSHAN = '' AND  SDDOCO = '' AND  SDLITM = '' AND  UPPER(SDDSC1) like '%%' AND  SDVR01 = '' AND  SDTRDJ = '' AND  SDDRQJ = '' AND  SDPPDJ = '' AND  SDSOBK > 0
2022-02-21_16-26-09.png
2022-02-21_16-26-09.png (28.18 KiB) Viewed 1177 times
2022-02-21_16-26-09.png
2022-02-21_16-26-09.png (28.18 KiB) Viewed 1177 times
word count: 99
Top
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:
Contact SteveCap

Re: Ignore Blank Issue

Unread post by SteveCap »

It appears you are running a query against JDE which would be using ECC. Is your ECC all the way upgraded? This should have been fixed in revision 97.
word count: 29
Top
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:
Contact CathyC

Re: Ignore Blank Issue

Unread post by CathyC »

I upgraded ECC. Safa, try now
word count: 6
Top
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:
Contact SteveCap

Re: Ignore Blank Issue

Unread post by SteveCap »

Did upgrading ecc solve the issue?
word count: 6
Top
smoady
Posts: 23
Joined: February 4th, 2022, 3:52 pm
Contact:
Contact smoady

Re: Ignore Blank Issue

Unread post by smoady »

Yes it did, thanks
word count: 4
Top
Post Reply

Return to “General Forum”