Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Dumb question?
Dumb question? [message #592946] Sat, 30 August 2008 09:58
Andrew is currently offline 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?
Previous Topic:Problems implementing an External Result Set Viewer
Next Topic:To clear up some confusion regarding the committer election for Enrico...
Goto Forum:
  


Current Time: Tue Sep 23 04:33:38 GMT 2014

Powered by FUDForum. Page generated in 0.01618 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software