Error Trapping!

[75cl]

What is a good way of traping error under this situation. let say i am importing data from the excel worksheet to a flexgrid using adodb connection. and I want to be able to continue my importing process when an error arise and be able to keep track of the number of bad record and good record. Anyone have any good idea of how to approach this. Thank you in advance

 

[NickISD]

Hi,
You've got two types of errors to trap for. 1 where data in the Excel sheet is missing or invalid and causes ADO to error or 2 the Flex grid errors on update which in my experience is very rare. You could trap the errors with an on error goto and resume and the bottom of the loop so the next record is then accessed and either message box the row number where the error occurred or write the Excel data out to an error.txt file for later examination.

Hope this helps

Nick W

 

[JohnYingling]

I like to trap them where they live

Dim lngErr as long
Dim strErr as string

On Error Resume next
    yadda
    lngerr = err.Number
    if lngerr <> 0 then strErr = Err.Description
On error goto 0
If LngErr <> 0 then
    Checkerror lngErr,strErr ' Come back only if OK, else Err.Raise
else
    ProcessRecord .....,...
End if

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript