At 07:19 AM 8/2/2006, you wrote:

>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:
>....
>What is the correct synatx to do this? (It works in MSSQL and Sqlite)
>
>
>
>SELECT E.ROWID, E.* FROM EVENTS E

works for me....

./dm

>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>