Hi,

I have a problem using IB_DSQL. I try to create a stored procedure
as follows :

create procedure saw_getarttext (artikelnr varchar(20),
groesse varchar(10))
returns (text varchar(255))
as

begin
select artikeltext from Artikel
where artikelnr = :artikelnr
and groesse = :groesse
into :text;

suspend;
end

the following code shows an error :

IB_DSQL1.SQL.LoadfromFile('C:\saw_getarttext.prc');
if IB_Transaction1.InTransaction then IB_Transaction.Commit;
IB_Transaction.StartTransaction;
IB_DSQL1.Execute; // or IB_DSQL1.ExecSQL; same error occurs
IB_Transaction.Commit;

An errormessage is shown like :
Unkown Datatype : 0

I also tried it with : Set Term ^;
But then an errormessage is shown like : unknown token at line 1
position 5 : term

What is wrong with it?

Please help.


Best greetings

Ronni