|
| Iniciado por guest, 18,nov. 2017 21:19 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 18,noviembre 2017 - 21:19 |
I am accessing an Excel file as a Data table connecting by OLE DB.
When the file format is correct it works beautifully however,
if I (or the user) selects a file that has the incorrect format I get
that horrible "Fatal Programming Error" window and the program ends.
I am trying to capture the error and send a message to the user that
he has selected a file with the incorrect format . . .
I have not found the right alchemy!
When I open the window, and "End of initialization" I refresh the table with:
TableDisplay(TABLE_QRY_IMP_BOSS, taReExecuteQuery)
I am placing all my error traps right after this command but I still get
that horrible "Fatal Programming Error" window and the program ends.
This is an example of the code that I have attempted:
IF HOnError(BOSS$,hErrAll) = True THEN
Info("There is a problem with the file that you are trying to load." + CR + "Please make sure it has the correct format")
RETURN
END
Can someone give me a hand pleezz . . . !
THNX !!
Joe Maldo |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,noviembre 2017 - 12:13 |
Hi Jose
look at 'when exception' in the help
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|