Get "No Data to Fetch"

[tdfreeman]

I have a query that I have created. I checked the SQL against the database and I get over 600 rows returned. In the Query Panel for the query I click on SQL. I then click on the Parse button and I get that the SQL script contains no errors.

Anyone have any ideas why my query would return no data.

I was changing a query that already worked. It originally said get all documents for fiscal year 2002 before accounting period 07. I added that it is to get all records before fiscal year 2002. This part of my SQL looks as follows:

AND (MF_ACTG_PERD.FISC_MNTH <= '07'
AND MF_ACTG_PERD.FISC_YEAR = '2002'
OR MF_ACTG_PERD.FISC_YEAR < '2002')

Other than that, there are no changes.

 

[suj2000]

Hello,

The problem is with the parenthesis.
It should be the following way


AND (MF_ACTG_PERD.FISC_MNTH <= '07'
AND MF_ACTG_PERD.FISC_YEAR = '2002')
OR (MF_ACTG_PERD.FISC_YEAR < '2002')

Try out it....This should resolve your problem.
Ajit