Displaying a failed line to the user

Hi,
I read data from a file and copy each element in each row to an array. I then assign each element in the array to the correct datatype before passing to a stored proc to load into a table. E.g

strArray() = Split(strLine, ",")

dteInvoice = strArray(0)
lngNumber = strArray(1)

If the data is invalid and hence can't be stored in that particular datatype, it jumps to my error handler and captures the error code.

I would then like to display a message that strArray(x) is invalid.

Without having a counter that stores the value of x is there anyway of displaying the value of the current variable being processed?

not really... there are other methods, but the way you suggested is the easiest and the quickest (as other methods would mean repeating the same code with similar modifications anyway)

by the way, you could do some simple checking first, eg:

VB Code:

If IsDate(strArray(0)) Then
  dteInvoice = strArray(0)
Else
  'error in date - show appropriate message & exit
End If
 
If IsNumeric(strArray(1)) Then
  lngNumber = strArray(1)
Else
  'error in number - show appropriate message & exit
End If

but that wont completely stop errors occuring

Thanks that's useful but it wouldn't trap other errors like overflow,etc.

I'll stick with using an index counter and just check it in the error handler. It was speed I was concerned with though