SELECT c.*, (1+1) AS test FROM CITIES c

Best Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: truewodzu
To: firebird-support@yahoogroups.com
Sent: Wednesday, April 13, 2011 11:50 AM
Subject: [firebird-support] Could you help me with basic SELECT queries, please?



Hi guys.

I just don't get why this SELECT statements doesn't work as they work on the MS SQL Server. I know, two different engines. But what am I doing wrong?

FIRST EXAMPLE:

SELECT 5

I would expect to get a result with one row and one column and the value 5, instead of I am getting this error in FlameRobin:

Preparing query: SELECT 5
Error: *** IBPP::SQLException ***
Context: Statement::Prepare( SELECT 5 )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 8

SECOND EXAMPLE:

SELECT *, (1+1) AS test FROM CITIES

Again, I would expect to have in each row a column called "test" with the value of 2 in it. Instead:

Error: *** IBPP::SQLException ***
Context: Statement::Prepare( SELECT *, (1+1) AS test FROM CITIES )
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 9
,

I don't get it. The comma is an unknown token, why?

THIRD EXAMPLE:

set term ^ ;

EXECUTE BLOCK
AS
DECLARE VARIABLE var_SecondsOfTime INTEGER;

BEGIN
SELECT 1 from RDB$DATABASE into :var_SecondsOfTime ;
SELECT var_SecondsOfTime ;
END
^

set term ^ ;

I would expect to get one row, one column with the value hold by the variable var_SecondsOfTime. But again, there is an error:

Preparing query:

EXECUTE BLOCK
AS
DECLARE VARIABLE var_SecondsOfTime INTEGER;

BEGIN
SELECT 1 from RDB$DATABASE into :var_SecondsOfTime ;
SELECT var_SecondsOfTime ;
END

Error: *** IBPP::SQLException ***
Context: Statement::Prepare(

EXECUTE BLOCK
AS
DECLARE VARIABLE var_SecondsOfTime INTEGER;

BEGIN
SELECT 1 from RDB$DATABASE into :var_SecondsOfTime ;
SELECT var_SecondsOfTime ;
END
)
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 9, column 28
;

Semicolon an unknown token???

I am struggling with such basic things.. it is very frustrating...
Thanks for your help.





[Non-text portions of this message have been removed]