--- In firebird-support@yahoogroups.com, "Craig" <cstevens@d...>
wrote:

> Hi All,
>
> Having a spot of bother with this statement
>
> SQLText := 'SELECT FIRST 1000 SKIP 10 * FROM '+UnFixTableName
> (TableName)+' ORDER BY '+GetQryField(TableName)+ ' ASCENDING';
>
> Keeps telling me i have an invalid token Line 2 Char 6 ',' <- this
> char right here. If i put fields in for the * it works, does this

mean

> you cannot use * in this syntax ?
>
> Thanks

Craig,

It is not the *

* works fine with this syntax.

Use a showmessage or equivalent to see the statement that is ACTUALLY
sent to the server, and post that if the problem is not obvious. My
guess is the order by function maybe puts a comma after the last
field unless you use some ancient join syntax and still put commas in
the from :)

Adam