How do you validate number of records imported against the data source record count?
I'm having some difficulty in validating the number of records I have imported into a .QVW against a count of the records from the data source.
Here is what I have so far:
SELECT COUNT(*) AS RowCtr
Let vSQLRecordCt = RowCtr;
Let vQVRecordCt = NoOfRows('ImportedReocrds')
If $(vSQLRecordCt) = $(vQVRecordCt) Then
Set vRecordCtValidation = 'Imported vs data source record counts match - extract process complete.';
Set vRecordCtValidation = 'Imported vs data source record counts do not match - Admin attention is required.';
It seems that my code is having a problem debugging at the If.. Then.. statement. I have tried a bunch of different combinations to try to feed to a variable the SELECT COUNT(*) result, but can't seem to find the proper way to do it.