Procedure calling

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
zippo
Silver Boarder
Silver Boarder
Posts: 322
Joined: 12.10.2005, 18:01
Location: Slovenia

Procedure calling

Post 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?
Michael
ZeosLib's Handyman :o)
ZeosLib's Handyman :o)
Posts: 189
Joined: 15.08.2005, 16:08
Location: Wehrheim
Contact:

Post 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.
:prog2: Use the source, dude!

[align=right]..::.. ZeosLib on SourceForge ..::..[/align]
Post Reply