[Lazarus] Reading results from a stored procedure

Antonio Fortuny a.fortuny at sitasoftware.lu
Thu Mar 8 15:05:58 CET 2012

I use such constructs since a long time ago. Check maybe the following 
1. is the user connected to the database allowed to use the procedure 
2. the lazarus component should be a query allowing the application to 
obtain a cursor (TSQLQuery).

Otherwise I made a quick test and it works with IB Objects.


Le 08/03/2012 14:33, Richard Mace a écrit :
> 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
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20120308/87de823d/attachment-0003.html>

More information about the Lazarus mailing list