Discussion Board for collaboration related to QlikView App Development.
I have a straight table with data. The columns are
Name, DateEntered, DaysinQueue.
All the records are updating from access database. But there ate two records in access database with DateEntered as 28/04/2014 12:16:36 and another record with DateEntered as 28/04/2014 13:43:18. Only these two records are not updating in the file.
Could anyone suggest me how to get this records?
Almost everyone has suggested a reason or a cause of the record not being visible even after that you do not see it then it would be great if you can share your QVW and can let us know which exact record (record ID) you have in the database and not being pulled to the QVW.
LOAD Rowno() as Rowno,
SQL SELECT *
STORE Tbl INTO C:\Extractor\Tbl.qvd;
DROP TABLE Tbl;
EDIT: It is showing a message as ODBC read failed after loading 3016 records. Will this be the problem?
could be. if you have database interface tool like sql+ or sql developer then try to run the same script in there and check if you are getting the same error or not.
you may also check the detail error message.
unfortunately I don't have any other environment to run this. It is not showing any detailed error message it is showing only QVX_Unexpected_End_of_data. as in attached. How can I set this please help me.