Milan Babuskov wrote:

> sqlsvr wrote:
>> In SQL Server, you can do this in the Query Analazyer (which executes a query and displays the results):
>>
>> SELECT 'a' AS column1;
>
> SELECT 'a' AS column1 FROM RDB$DATABASE;
>
>> You can also do this:
>> DECLARE @somevariable INT;
>> SET @somevariable = 1;
>> SELECT @somevariable;
>>
>> Can someone translate this to Firebird SQL?
>
> set term ^ ;
> execute block returning ( somevariable integer ) as
> begin
> somevariable = 1;
> suspend;
> end^

Sorry, it should have been "returns" instead of "returning"

set term ^ ;
execute block returns ( somevariable integer ) as
begin
somevariable = 1;
suspend;
end^


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================