Re: Problem with creating a stored procedure

[Mike Markgraf]

I actual got it workings, thanks for the help though. It seems like the Begin statement was what was causing the issue. This is what I used.

CREATE PROCEDURE `sp_addChild` (
IN `CID` int,
IN `fname` varchar( 50 ) ,
IN `lname` varchar( 50 ) ,
IN `DOB` DATETIME,
IN `gender` varchar( 10 ) ,
IN `goals` varchar( 255 ) ,
IN `nameMeaning` varchar( 255 ) ,
IN `orphaned` tinyint,
IN `family` varchar( 255 ) ,
IN `eligible` tinyint,
IN `notes` varchar( 255 )
)
INSERT INTO Children(
Child_ID,
Child_Fname,
Child_lname,
Child_DOB,
Child_gender,
Child_goals,
Child_nameMeaning,
Child_orphaned,
Child_family,
Child_eligible,
Child_notes
)
VALUES (
CID, fname, lname, DOB, gender, goals, nameMeaning, orphaned, family, eligible, notes
);