>>>We have a cold fusion front end to one of our apps. It will work fine for months on end. Then suddenly it will begin to fail. We have tracked this failure down to one line of code in a Stored Procedure.
>>>
>>>

>>>Local < variable >
>>>

>>>
>>>It almost seems as if the variable has been cached as public. If you declare a variable public and then try to re-declare it as local it will error out.
>>>
>>
>>What is the error # and message?
>
>The problem with the cold fusion front end, there really isn't a meaningful error. It just says that there is a violation with the Record Validation. You can't even put a step on to see where the error is occuring. The web front end is talking to the foxpro database through the ODBC connection. We are using a dummy table and insering a record in that table to call a stored procedure.
>

It sounds like the stored procedure is an insert trigger. Does your ON ERROR routine log errors into a table? By doing this, you can find out the program, line number, and error number, which can help you diagnose these kinds of problems.