I changed the labeled common in an include file that is included in all of my stored procedures. I re-compiled all of the stored procedures but I still get "Labeled common created smaller than declaration" when I go to run them. Sometimes the app will work fine for a little bit then I'll get the errors again. Also, since the same include file is in all the code behind my windows events is there any way to recompile all of the forms at once?

Thanks,

Bryan

Bryan,

If I remember right a Labeled Common does not change until the session ends.

So if you Logoff then back on all should be okay.

Be sure that all Stored Procedures and all Events have been re-compiled.

dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"

David Tod Sigafoos ~ SigSolutions

voice: 503-639-8080

Thanks for the reply. How do I force a re-compile all of the events at one time?

Thanks,

Bryan

Thanks for the reply. How do I force a re-compile all of the events at one time?

Thanks,

Bryan

You can also use the FreeCommon subroutine to remove a common declaration.

 Duane Pekse

 ALDATA Software Management Inc.

 duanep@aldatasoftware.com

View this thread on the forum...