Subject TIBOStoredProc
Author James
To answer my question (yes, pretty simple):
For an output type stored proc TIBOStoredProc needs to have an output param which
is then accessed as Params[0].AsXXX after execution. So, adding a parameter to my
storedProcedure component and then accessing it as follows works:

with StoredProc do begin
StoredProcName := SPPREFIX + Tablename;
try
Prepare;
Execproc;
Result := StoredProc.Params[0].AsInteger;
finally
{myParam.Free;}// component is on datamodule
end;
end;

Thanks (found a clue in the online help afterall).


__________________________________________________
Advertise with ZFREE - to find out more click below
http://www.zfree.co.nz/about-us/advert.html