Re: SELECT FIRST ... INTO TEMP ...

On Tue, 08 Jun 2004 04:11:09 -0400, Doug Lawry wrote: Feature. In hte Guide to SQL Syntax manual is a list of situations in which the FIRST clause may NOT be used. SELECTs that are part of an INSERT statement or which contain an INTO TEMP clause are on that list. Art S. Kagel > 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