From time to time, I have to use Visual Basic in Calculate field.
As the code get bigger, the more complicated is to debug it. And ArcGIS (9.3) does not help as the error messages are, in the best cases, something like:
"A field name was not found or there were unbalanced quotation marks. ERROR 999999: Error executing function. Failed to execute (Calculate Field)."
It's not very informative, has an ambiguous reference to the type of error and does not say the line of the code where the error occurred.
So my question is: Is there a better way to debug the code in ArcGIS? Anyone has strategies to share, or a parallel software or site to do it?