|Dumb question? [message #592946]
||Sat, 30 August 2008 05:58
Registered: July 2009
Apologies in advance if I have missed something obvious, but after a few |
hours searching the newsgroups and various websites, I am at a loss.
I am trying to create stored procedures in MySQL, which requires that I
use terminators within the body of the procedure.
After scanning through the DTP code it looks like DTP will always split
the body of the procedure at each terminator. So something like:
CREATE PROCEDURE Client_InsertClient (
INOUT clntid INTEGER,
DECLARE oldclntid INTEGER;
SET oldclntid = clntid;
INSERT lead_client (
SET clntid = LAST_INSERT_ID();
Is never going to be executed successfully by DTP? Looking at the Results
view, it appears to split into individual statements which are therefore
incomplete and not executable.
Have I missed something?