Eclipse Community Forums: DTP

Help

Home

Home » Eclipse Projects » DTP » Dumb question?

Show: Today's Messages :: Show Polls :: Message Navigator

Dumb question? [message #49497]

Sat, 30 August 2008 05: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?

Report message to a moderator

[Message index]

		Dumb question? By: Andrew on Sat, 30 August 2008 05:58
		Re: Dumb question? By: Eclipse User on Tue, 02 September 2008 10:33
		Re: Dumb question? By: Andrew on Tue, 02 September 2008 18:32
		Re: Dumb question? By: Eclipse User on Wed, 03 September 2008 05:41
		Re: Dumb question? By: Andrew on Thu, 04 September 2008 18:20
		Re: Dumb question? By: Eclipse User on Mon, 08 September 2008 05:43
		Re: Dumb question? By: Andrew on Mon, 08 September 2008 09:46
		Re: Dumb question? By: Andrew on Mon, 08 September 2008 09:46
		Re: Dumb question? By: Eclipse User on Mon, 08 September 2008 05:43
		Re: Dumb question? By: Andrew on Thu, 04 September 2008 18:20
		Re: Dumb question? By: Hui Cao on Wed, 03 September 2008 05:41
		Re: Dumb question? By: Andrew on Tue, 02 September 2008 18:32
		Re: Dumb question? By: Eclipse User on Tue, 02 September 2008 10:33

Previous Topic:	Listening to SQL Results
Next Topic:	Problem with Data Source Explorer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 12:24:40 EDT 2013