Can it use in Firebird 2 's EXECUTE BLOCK command?
Brought to you by:
aldettmer,
bsstmiller
In Firebird 2 there are EXECUTE BLOCK command can use
like a DML,But Delphi Can't translate the input and
return parameters,I try TSQLScript/TSQLConnectionPlus
also.
for example:
Delphi SQL Source -
EXECUTE BLOCK (X INTEGER=:X) RETURNS (Z INTEGER)
AS
BEGIN
Z =:X;
UPDATE Table1 SET Field1 = :X;
END;
after Paser SQL -
EXECUTE BLOCK (X INTEGER=?) RETURNS (Z INTEGER)
AS
BEGIN
Z =? ;
UPDATE Table1 SET Field1 = ?;
END;
then you will get Error.
Can dbExpress Plus modify this problem?