<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I use such constructs since a long time ago. Check maybe the
following points:<br>
1. is the user connected to the database allowed to use the
procedure (grants)<br>
2. the lazarus component should be a query allowing the application
to obtain a cursor (TSQLQuery).<br>
<br>
Otherwise I made a quick test and it works with IB Objects.<br>
<br>
Antonio.<br>
<br>
<br>
Le 08/03/2012 14:33, Richard Mace a écrit :
<blockquote
cite="mid:CAK+KT3-KnSjQg6BH-7CKm6cG01=8jYzF1gOkZa_ZrtpUPCrDxA@mail.gmail.com"
type="cite">
<div id="WISESTAMP_SIG_1896">
<div
style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif">Hi
All,<br>
I am trying to call a firebird stored procedure (called
GETALLUSERS) from within Lazarus (Win 7) using the following
code:<br>
<br>
fSQLQuery.SQL.Text := 'SELECT resultvar from GETALLUSERS';<br>
fSQLQuery.Open;<br>
<br>
However, I get an error saying that the table "GETALLUSERS"
cannot be found.<br>
Could someone give me an example of how I can use the built in
sqldb components to accomplish this?<br>
<br>
Thanks in advance<br>
<br>
Richard<br>
<img moz-do-not-send="true"
src="http://p1.wisestamp.com/pixel.png?p=mozilla&v=3.9.12&t=1331212904368&u=7b060e580c4ca423"
height="1" width="1"></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">--
_______________________________________________
Lazarus mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Lazarus@lists.lazarus.freepascal.org">Lazarus@lists.lazarus.freepascal.org</a>
<a class="moz-txt-link-freetext" href="http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus">http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus</a>
</pre>
</blockquote>
</body>
</html>