Hello,
I am exporting the data of a LN databse to an excel file on a daily basis.
Since yesterday, I have this message when exporting :
"Sorry. An uncorrectable error has occured.
LookupHandle: null handle
Press enter to abort the application"
I added a column to the database yesterday, maybe that’s the reason.
A colleague can export the data without any problem, even after the column add.
Could you help me to solve this problem?
Thanks in advance
Subject: LN database - export to excel failed
Normally this type of error is due to a missing or wrong reference. You are trying to access something via a variable that has no value or the wrong value.
Without any more information, like the relevant code, nobody will be able to help you. Please try to limit the code to the essentials; nobody will read thousand lines of code.
In the meantime you could add checking to your code. So after every “set xxx = [something]” statement check the result for not being “nothing” and give an appropriate error message.
Subject: RE: LN database - export to excel failed
Hello, sorry, I’m a functionnal user, could you tell me how to find the code?
Thanks for the support.
Subject: RE: LN database - export to excel failed
Guessing from your inital message, I can only deduce that there is something wrong with your code. But when you do not know how to debug this (I don’t blame you for this), I would suggest that you get somebody to assist you, who knows about debugging.
This forum is not the place to give you a course in debugging.
Subject: RE: LN database - export to excel failed
Ok, thanks anyway.