Displaying a failed line to the user

[nmcbride]

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?

[si_the_geek]

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)

[si_the_geek]

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

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

[nmcbride]

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