> >> Fb 3 introduces local sub routines in stored procedures. >> >> It seems these sub routines cannot call themselves nor can then call >> previously declared routines, this is, I assume, by design? >> > >README.subroutines.txt: > >Limitations: > 1) Subroutines may not be nested in another subroutine. They are >only supported in the main > routine.
That I figured out. > 2) Currently, a subroutine may not directly access or use variables, >cursors or another > subroutines of the main statements. This may be allowed in the >future. Right. But how about a recursive call to itself? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel