Recompile_Proc subroutine [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Recompile_Proc subroutine   ======


 
==== Description ====
 
Recompiles one or more specified stored procedures.
 
==== Syntax ====
 
**Recompile_Proc**(//procnamelist//)
 
==== Parameters ====
 
The Recompile_Proc subroutine has the following parameter.

^Parameter^Description^
|//procnamelist//|Specifies a name or list of names of stored procedures to recompile.\\ |


Note:  Stored procedures can also be recompiled using the [[compile|Repository('COMPILE')]] function, or the [[rtp5|RTP5 subroutine]].\\ \\ Note:  [[dollar_insert|$INSERT records]] in a stored procedure are not recompiled by Recompile_Proc.  However, they are recompiled by the [[compile|Repository('COMPILE')]] function.

 
==== See Also ====
 
[[compile|Repository('COMPILE')]], [[tcompile|Repository("TCOMPILE")]], [[rtp5|RTP5 subroutine]]
 
==== Example ====
 
<code>
* Recompiles the QUICK_REPORT stored procedure.

Recompile_Proc("QUICK_REPORT")

If Get_Status(ErrCodes) Then
  GoSub ErrorHandling
End
</code>