Subject select statments with both "*" and specific rows
Author yoav112003
Hello

I am trying to run the following query:

SELECT rowid, * FROM Events;

This should return a result set with the column rowidall followed
columns of the table (including rowid again). However, FB replies with
the following error:

*** IBPP::SQLException ***
Context: Statement::Prepare( SELECT rowid, * FROM Events_EVENT )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 15
*

What is the correct synatx to do this? (It works in MSSQL and Sqlite)