Home » Eclipse Projects » DTP » Dumb question?
Dumb question? [message #592946] |
Sat, 30 August 2008 09:58 |
Andrew Messages: 8 Registered: July 2009 |
Junior Member |
|
|
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,
typecodeid INTEGER,
firstname VARCHAR(45),
lastname VARCHAR(45),
titlecodeid INTEGER,
gendercodeid INTEGER,
dob DATE,
salutation VARCHAR(45),
homephone VARCHAR(20),
busphone VARCHAR(20),
mobilephone VARCHAR(20),
otherphone VARCHAR(20),
countryid INTEGER)
BEGIN
DECLARE oldclntid INTEGER;
SET oldclntid = clntid;
INSERT lead_client (
clnt_type_code_id,
clnt_firstname,
clnt_lastname,
clnt_title_code_id,
clnt_gender_code_id,
clnt_date_of_birth,
clnt_salutation,
clnt_home_phone,
clnt_bus_phone,
clnt_mobile_phone,
clnt_other_phone,
clnt_country_id
)
VALUES (
typecodeid,
firstname,
lastname,
titlecodeid,
gendercodeid,
dob,
salutation,
homephone,
busphone,
mobilephone,
otherphone,
countryid
);
SET clntid = LAST_INSERT_ID();
END
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?
|
|
|
Goto Forum:
Current Time: Sat Apr 27 01:40:58 GMT 2024
Powered by FUDForum. Page generated in 0.04835 seconds
|