Menu

#4 Can it use in Firebird 2 's EXECUTE BLOCK command?

open
nobody
5
2014-08-23
2006-03-23
Anonymous
No

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?

Discussion


Log in to post a comment.

MongoDB Logo MongoDB