Subject | Re: How to execute Stored Procedure code directly from Delphi ? |
---|---|
Author | Mario |
Post date | 2005-07-15T13:44:24Z |
With ParamCheck set to False, the error code is now -206 Column unknown.
I have also tried to run it with all statements between the begin and
end keywords temporarily removed and with ParamCheck set to True. In
that last case, it crashes on the last line: -104 Token unknown - line
5,char -1 End'.
as in:
I have also tried to run it with all statements between the begin and
end keywords temporarily removed and with ParamCheck set to True. In
that last case, it crashes on the last line: -104 Token unknown - line
5,char -1 End'.
as in:
> Transaction.StartTransaction;Mario
> SQL.Clear;
> SQL.Add('ALTER PROCEDURE GETSTDDEV(FIRSTDATE TIMESTAMP)');
> SQL.Add('RETURNS(AVGINDEX REAL,COUNTINDEX INTEGER,STDDEV REAL)');
> SQL.Add('AS');
> SQL.Add('Begin');
> SQL.Add('End');
> ExecQuery;
> Transaction.Commit;
--- In firebird-support@yahoogroups.com, Nando Dessena <nando@d...> wrote:
> Mario,
>
> M> I am now getting an error on the SQL line which includes the
statement:
> M> SQL.Add('into :stddev;');
>
> set ParamCheck to False.
>
> Ciao
> --
> Nando Dessena
> http://www.flamerobin.org