How can I see a record count on a qvd load?

[#1]

I am trying to use this code:

    IterNo() AS Key

While IterNo() <= NoOfRows ('MyTable');

when I run the script it returns with no records.

I am trying to figure out which record my script is crashing on.  I am getting this error:

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294967135, ErrorMsg: [CA][ODBC CA-Datacom/DB Driver][CA-DATACOM/DB] FIELD_NAME1 NUMERIC(7,0) INVALID DATA: F0F0F0D761E4FF

where FIELD_NAME1 is numeric with the invalid data and my script fails at this point.

Is there a way to display the other fields on the bad record to a log file?

[eddysanchez]

Are you trying to connect to Oracle?

If you use the sentences:

SQL SELECT...

All this SQL command is not compiled in qlikview. Is compiled in your provider

[#3 · Accepted solution]

HI,

     You can use as below code

Let rowcount=NoOfrows('MyTable');

Trace $(rowcount)

By using this the Records count of the Table is visible in the Script Execution Dialog as well

as in the Log file .

Please reply me for the same.

//yusuf