Subject | select statments with both "*" and specific rows |
---|---|
Author | yoav112003 |
Post date | 2006-08-02T12:19:10Z |
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)
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)