The issue reporter gave this example: select ORDERNO as OrderNo from ORDERS as Orders; It does parse AS, but only for a field.
Michael Van Canneyt replied: TSQLParser implements SQL syntax as used in Firebird, and firebird does not allow AS for a tablename, just append the alias. The correct syntax would be: select ORDERNO as OrderNo from ORDERS Orders; However: On my Firebird 2.5, this works perfectly (in FlameRobin and SQLWorkBench/J): select * from rdb$relations as tables; Would it make sense to reopen this bug? Thanks, Reinier _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
