Zeoslib Portal

found the answer. use TZStoredProc built for this very reason. proc := TZStoredProc.Create(nil); proc.StoredProcName := 'PROC_DO_ICD'; proc.ParamByName('INID_FLT').AsInteger := serverid; proc.ParamByName('INTY_ICD').AsInteger := Ord(icd); proc.ParamByName('INID_ICD_TO').AsInteger := ParentDoc; proc....

How do I get a resultant parameter from a stored procedure: CREATE PROCEDURE PROC_DO_ICD (INID_FLT T_IDENTITY ,INTY_ICD TY_SRC ,INID_ICD_TO T_IDENTITY ,INDE_DO_ICD T_DESCRIPTIONSHORT ) RETURNS ( OUTID_ICD_TO T_IDENTITY ) calling the below statement EXECUTE PROCEDURE MY_PROC_DO_ICD 2, 2,0,"Invoi...

Hi Mark,
We will be purchasing Delphi XE this week.
What can I do to get these changes into the main branch of zeoslib?

How can I become an alpha tester?
I want to test revision 813 ( because of delphi XE )

After much stuffing around i found out that using subversion i can get this version at svn://zeos.firmos.at/zeos/branches/testing it also compiles under Delphi XE! We should be using Delphi15 for DelphiXE and not modifying Delphi14

How do I get this version of ZeosLib?

Success! 1. I wrote my own proc to seperate out SQL's 2. I called the below: try stmt := FConDB.DbcConnection.CreateStatement; stmt.ExecuteUpdate(slSQL.Text); except on E:Exception do begin result := False; GenerateSQLError(slSQL,SQLName,E.Message); end; end; stmt:=nil; So much troubles now resolved...

Unfortunately this does not solve my problem even with your stored proc. I get the same problem. I am using your suggestion: Dynamic SQL Error SQL error code = -104 Token unknown - line 14, column 15 then. Error Code: -104. Invalid token With storedprocs I get Dynamic SQL Error SQL error code = -104...

I cannot at any time create a firebird stored procedure using
any ZeosLib component. I have tried them all.

My stored procedures compile nicely in Database WorkBench, IBOConsole.

But I cannot get ZeosLib to create them

Has anyone else had this problem?