Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

Finding skipped records


mwassmer Jun 1, 2010 03:15 PM

The station status table reports the number of skipped records, but I'm struggling to find an efficient way to actually locate the skipped records in my data table. Do you have any recommendations?

Thanks,
Mike


Dana Jun 1, 2010 07:57 PM

One option is to monitor the SkippedRecord status table value (it is a counter), and if it changes from one scan to the next, then write a record to a data table.

Status table values can be assigned to a variable (or used as they are in an instruction) using the data table access syntax (see the help file ); e.g.,

SkippedRecs(1) = Status.skippedRecord(1)

variable = tablename.fieldname

There may be easier ways, but this is one I can think of right now (the way above doesn't do you any good with existing data).

Regards,

Dana W.

Log in or register to post/reply in the forum.