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
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
