SELECT FIRST ... INTO TEMP ...
Why doesn't this work?! For example (in 9.30.HC1 or 9.40.TC2):
SELECT FIRST 10 * FROM systables INTO TEMP temptable
SQL Error (-944): Cannot use 'first' in this context.
$ finderr -944
-944 Cannot use "first" in this context.
This statement uses FIRST N inside a subquery. This action is
not supported.
Review the use of FIRST N and check that it is applied only
to the outer main query SELECT pause.
This is really inconvenient! Is it a listed bug or feature request?
--
Regards,
Doug Lawry
www.douglawry.webhop.org