Re: [Flamerobin-devel] Parameter driven queries

[Milan B. <mil...@gm...>]

On Thu, May 5, 2011 at 9:57 AM, Andre van Zuydam <an...@sp...> wrote:
> Any thoughts of a pseudo SQL to pass Params in Flamerobin, basically the syntax would work like this
>
> declare i = 100;
> declare n = 'Name';
>
> select * from sometable where somefield = :n and someint > :i;

How is that any different from:

set term ^ ;

execute block as
declare variable i integer;
declare variable n varchar(20);
begin
    i = 100;
    n = 'Name';
    select * from sometable where somefield = :n and someint > :i;
end

?

> if it hasn't been, who would like it implemented, I'm game to do this development ???

There were some talks about implementing something like that before,
but since EXECUTE BLOCK is introduced into Firebird I fail to see any
reasons. Especially with new templating we will have in FlameRobin
0.9.4. where you will be able to create custom predefined EXECUTE
BLOCK constructs for any table.


--
Milan Babuskov
http://www.guacosoft.com