how to execute SP with TZSQLProcessor

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

irw10062
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 27.02.2009, 07:12

how to execute SP with TZSQLProcessor

Postby irw10062 » 20.11.2012, 09:53

please help me,
how to execute this script with TZSQLProcessor because its failed caused by string delimiter $$
and default is ;

drop table if exists mastergudangx;
CREATE TABLE `mastergudangx` (
`kd_gdg` varchar(20) NOT NULL,
`nm_gdg` varchar(20) NOT NULL,
`keterangan` varchar(30) DEFAULT NULL,
`kd_subdist` varchar(15) NOT NULL,
PRIMARY KEY (`kd_gdg`),
KEY `Index_mastergudangx_kd_subdist` (`kd_subdist`,`kd_gdg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=0;

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_update_tglpjp`()
BEGIN
replace into mastersetting select 'tglpjp', setting from mastersetting where nama_setting='tglgudang';
END $$
DELIMITER ;

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1734
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 20.11.2012, 13:24

irw10062,

Did you set TZSQLProzessor.DelimiterType = dtDelimiter? I use such scripts for my test and it works like expected.

Another thing i could imagine: Add a line ending(press enter) behind "end $$".

Can you vaidate this first?
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “MySQL”

Who is online

Users browsing this forum: No registered users and 1 guest