Thanks Sergey, I'll look at wrapping our sql views.
>You can wait for VFP8 that has TRY CATCH FINALY structured error handler. Otherwise you can wrap CREATE SQL VIEW in a class and use its ERROR() Event() to catch error.
>
>>
>>Is there a best practice or workaround on how to trap the error 1463: "No result set has been returned by the server", when creating views using CREATE SQL VIEW? I don't want to use the ON ERROR reassignment.
ramil
~~ learning to stand still