Discussion Board for collaboration related to QlikView App Development.
After an OLEDB CONNECT TO claue I am trying to use the following SQL statement in my QlikView Script:
SQL SELECT * FROM [JBVProcessDB01].[dbo].[tblEvent01]
SELECT MAX(DateTime) as LatestDate, [sFieldValue0]
Group by sFieldValue0
on [JBVProcessDB01].[dbo].[tblEvent01].DateTime = SubMax.LatestDate
and [JBVProcessDB01].[dbo].[tblEvent01].sFieldValue0 = SubMax.sFieldValue0 and lFieldValue2 > 2
But when I run the script I get an error message stating that "OLEDB read failed". This SQL query works fine in SQL management studio, and I have tested my OLEDB CONNECT TO statement which also works.
So what can be the problem here?
though too late, but just wanted to answer for others so that they do not find it unanswered
I had the same "OLEDB read failed" error. Which occurred due to duplicate columns names in the query. When removed, it worked.
View solution in original post
Nice work Sibtain Naqvi!
Thank you so much!