Page 1 of 1

Procedure calling

Posted: 09.12.2005, 17:35
by zippo
Hi!

Could be offtopic (moderator - remove if so!), but anyway...

How do I call stored procedures - functions in Zeos + MySQL 5.1? I tried this

Query.SQL.Text := 'Call MYPROC';
Query.ExecSQL;

Should I call ExecSQL or Open ?

How to use TStoredProc?

Posted: 09.12.2005, 18:49
by Michael
Hi zippo,

please take a short look at this ... There is a section concerning TStoredProc. You can also use it on Storedprocs in MySQL ;-).

Regards.