[Lazarus] Reading results from a stored procedure

[Richard Mace]

Hi All,
I am trying to call a firebird stored procedure (called GETALLUSERS) from
within Lazarus (Win 7) using the following code:

fSQLQuery.SQL.Text := 'SELECT resultvar from GETALLUSERS';
fSQLQuery.Open;

However, I get an error saying that the table "GETALLUSERS" cannot be found.
Could someone give me an example of how I can use the built in sqldb
components to accomplish this?

Thanks in advance

Richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20120308/7900e364/attachment-0002.html>