Don't forget to specify the condition carefully, otherwise you could end up with an infinite loop!As soon as you insert your CREATE PROCEDURE TBLSTATS RETURNS ( table_name VARCHAR(100), no_records Integer) BEGIN FOR SELECT r.rdb$relation_name FROM rdb$relations r WHERE r.rdb$relation_name NOT CONTAINING '$' INTO :table_name DO BEGIN EXECUTE STATEMENT 'select count (*) from '
Product datasheet Upgrade Price Guarantee Compatible with Windows 10, 8.1, 8, 7, Vista and XP, 32 Bit / 64 Bit Editions New language versions: Chinese - Lithuanian - Japanese - Polski - Romanian - Spanish - Czech Update Star is compatible with Windows platforms.
Update Star has been tested to meet all of the technical requirements to be compatible with Windows 10, 8.1, Windows 8, Windows 7, Windows Vista, Windows Server 2003, 2008, and Windows XP, 32 bit and 64 bit editions.
back to top of page The purpose is to stop execution of the current block and unwind back to the specified label.
After that execution resumes at the statement following the terminated loop.
An executable procedure returns no more than one set of variables. This usage is legal, but not recommended, and it is unfortunately an error that even experienced programmers often make.