Count is not matching with Record Set In qlikview script

[Anonymous]

Hi,

  When I am running below script in Qlikview it is giving correct count ie 1049873:

SQL SELECT count(1)

                    FROM DataSchema.Data_v

  WHERE business_date >= TO_DATE('2012-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS')

                    AND business_date <=  TO_DATE('2012-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS')

Where as if I run all the columns selections  then it is giving only just 2500 records

SQL  SELECT *

  FROM DataSchema.Data_v

  WHERE business_date >= TO_DATE('2012-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS')

  AND business_date <=  TO_DATE('2012-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS')

Is there any specific settings i need to provide to achieve this?.

I am using licenced version of qlikview and ODBC connector.

Thanks

Dasu.G

[alexandros17]

How do you count rows in resulting tables?

With the first query you just count the rows, the second query may "hide" rows if values are equal. Is this possible in your tables?

[Anonymous]

Ticket number and business date columns are different always. complete record set never matches at all..

[Anonymous]

Hi Guys,

   I found below logs from ODBC Driver?. Is there any thing to do with ODBC (We are using Composite 6.2 ODBC driver).

0002DED44EB9471 2dd74-2dd78	EXIT  SQLSetStmtAttrW  with return code -1 (SQL_ERROR)
		SQLHSTMT            0x00000000003EE260
		SQLINTEGER                   4 <SQL_ATTR_ASYNC_ENABLE>
		SQLPOINTER                 1 <SQL_ASYNC_ENABLE_ON>
		SQLINTEGER                  -6

[rwunderlich]

It sounds like your driver (or DB) is set to return a max of 2500 rows. Is that SalesForce you are hitting in the background?

-Rob

[Anonymous]

Hi Rob,

           I ran other queries and found that those are retrieving more than 2500 rows that means neither db nor database has this record limit configured. Do you have any thoughts how to proceed on these kind of situations?.

Thanks

Dasu.G

[Anonymous]

We found some issues in the composite ODBC driver . There is no issue in QV.