> 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 ?

Your string is single line, while the error is on line 2,
so obviously you are not telling us which command exactly
you are actually trying to execute.

Ivan