Page 2 of 2

Posted: 14.11.2006, 11:02
by que
Hehe.... i just found the solution for my problem:

Just added connection property
CLIENT_MULTI_STATEMENTS=true

After this calls to stored procs work in TZQuery :)

Posted: 22.11.2006, 19:34
by Rogier21
With the new release of ZEOS, can I just use the TZStoredProc component?

I use it like this and it looks really handy.

Code: Select all

  StoredProc1.Active:=False;
  StoredProc1.StoredProcName:='test_proc';
  StoredProc1.ParamByName('@param_id').AsInteger:=1;
  StoredProc1.ExecProc;
  StoredProc1.Active:=True;
But i get the same error as the topic starter; parameter not found (yet i tried more then this possibility ;) )