<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">W dniu 19.07.2013 09:38, Reinier
Olislagers pisze:<br>
</div>
<blockquote cite="mid:51E8ECFF.1000501@gmail.com" type="cite">
<pre wrap="">On 18/07/2013 17:40, Paul wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I have problem with TSQLScript (?)
Script looks like that
SET TERM ^ ;
CREATE PROCEDURE GET_USER_PRIVILEGES (
USER_ACCOUNT VARCHAR(10))
RETURNS (
RESULT CHAR(1))
AS
BEGIN
FOR
SELECT DISTINCT RDB$PRIVILEGE
FROM RDB$USER_PRIVILEGES
WHERE (RDB$USER = :USER_ACCOUNT)
INTO :RESULT
DO
BEGIN
SUSPEND;
END
END
^
SET TERM ; ^
and the error message looks like that
{...}PrepareStatement
-Dynamic SQL Error
-SQL Error Code = -104
Token unknown - line 11, column 11
-?
line 11 -> INTO :RESULT
column 11-> :
FlameRobin does not have any problems with this piece of code
Any hints ?
Paul
I use Lazarus 1.0.10, Firebird 2.5 on Ubuntu 32bit
</pre>
</blockquote>
<pre wrap="">
Not really, except it's a Firebird error and it would be interested to
know what actually gets passed to the Firebird engine (to verify if that
runs in FlameRobin).
Perhaps sqldb logging [1] would work for that?
[1]
<a class="moz-txt-link-freetext" href="http://wiki.lazarus.freepascal.org/SqlDBHowto#Troubleshooting:_TSQLConnection_logging">http://wiki.lazarus.freepascal.org/SqlDBHowto#Troubleshooting:_TSQLConnection_logging</a>
--
_______________________________________________
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>
<font face="Times New Roman, Times, serif">Only
TSQLScript.OnException is triggered with error message as above<br>
</font><font face="Times New Roman, Times, serif">I don't know why
but TIBConnection.OnLog event isn't triggered at all<br>
(even when </font><font face="Times New Roman, Times, serif"><font
face="Times New Roman, Times, serif">TSQLScript.OnException is
not assigned)</font> <br>
<br>
Paul<br>
</font>
</body>
</html>