[Lazarus] Reading results from a stored procedure

[Antonio Fortuny]

I use such constructs since a long time ago. Check maybe the following 
points:
1. is the user connected to the database allowed to use the procedure 
(grants)
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.

Antonio.


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>