>>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.