On 12-6-2011 16:22, firebirdsql wrote:

> I'm executing a query and would like to use a variable in flamerobin, how would I do it? The following fails (I don't want to create a stored procedure or a function)
>
> DECLARE VARIABE test VARCHAR(25);
> test = 'a';
> SELECT *, :test FROM accounts;

Use EXECUTE BLOCK:
http://www.firebirdsql.org/refdocs/langrefupd20-execblock.html

--
Mark Rotteveel