I have written a Stored Procedure that does an update
of a table triggered by the user of my VB client.
Sometimes this SP encounters division by zero and gives
me the message:
Divide by zero occurred.
This is Ok by me and by Enterprise Manager. The SP executes
what it is supposed to do anyhow. But from VB (using RDO)
it fails because of this error.
So the question is:
What can I do in my SP to prevent it from failing when
it is called by the VB-client?
I have tried with setting some options but it didnt work.