delimiter // strSQL = "create procedure sp_getundefinedcode(in AID char(8),out retCode int) proc: begin DECLARE v_workercode varchar(8);DECLARE v_stationcode varchar(8);DECLARE v_sitecode varchar(8);DECLARE v_eventcode varchar(8);DECLARE v_type char(2);SELECT sitecode INTO v_sitecode FROM TBL_SITE WHERE sitecode = AID;if !isnull(v_sitecode) then begin set retCode = 1;leave proc;end; end if;SELECT eventcode INTO v_eventcode FROM TBL_EVENT WHERE eventcode = AID;if !isnull(v_eventcode) then begin set retCode = 2;leave proc;end;end if;SELECT workercode INTO v_workercode FROM TBL_WORKER WHERE workercode = AID;if !isnull(v_workercode) then begin\ set retCode = 3;leave proc;end;end if;SELECT stationcode INTO v_stationcode FROM TBL_STATION WHERE stationcode = AID;\ if !isnull(v_stationcode) then begin set retCode = 4;leave proc;end;end if;set retCode = 0;end;// delimiter ;"; if(mysql_query(&mysql,(char*)(LPCTSTR)strSQL)) { MessageBox(mysql_error(&mysql)); return FALSE; } 错误:You have an error in your syntax:check the manual that corresponds to your mysql server version for the right syntax to use near 'delimiter // create procedure sq_getundefinedcode(in ALD char(8),out retCode int' at line 1请这位仁兄帮忙解决一下,先谢过!
不好意思, 有误.是 strSQL = "delimiter // create procedure sp_getundefinedcode(in AID char(8),out retCode int) proc: begin DECLARE v_workercode varchar(8);DECLARE v_stationcode varchar(8);DECLARE v_sitecode varchar(8);DECLARE v_eventcode varchar(8);DECLARE v_type char(2);SELECT sitecode INTO v_sitecode FROM TBL_SITE WHERE sitecode = AID;if !isnull(v_sitecode) then begin set retCode = 1;leave proc;end; end if;SELECT eventcode INTO v_eventcode FROM TBL_EVENT WHERE eventcode = AID;if !isnull(v_eventcode) then begin set retCode = 2;leave proc;end;end if;SELECT workercode INTO v_workercode FROM TBL_WORKER WHERE workercode = AID;if !isnull(v_workercode) then begin\ set retCode = 3;leave proc;end;end if;SELECT stationcode INTO v_stationcode FROM TBL_STATION WHERE stationcode = AID;\ if !isnull(v_stationcode) then begin set retCode = 4;leave proc;end;end if;set retCode = 0;end;// delimiter ;"; if(mysql_query(&mysql,(char*)(LPCTSTR)strSQL)) { MessageBox(mysql_error(&mysql)); return FALSE; } 错误:You have an error in your syntax:check the manual that corresponds to your mysql server version for the right syntax to use near 'delimiter // create procedure sq_getundefinedcode(in ALD char(8),out retCode int' at line 1 请这位仁兄帮忙解决一下,先谢过!
set retCode = 3;leave proc;end;end if;SELECT stationcode INTO v_stationcode FROM TBL_STATION WHERE stationcode = AID;\
if !isnull(v_stationcode) then begin set retCode = 4;leave proc;end;end if;set retCode = 0;end;// delimiter ;";
if(mysql_query(&mysql,(char*)(LPCTSTR)strSQL))
{
MessageBox(mysql_error(&mysql));
return FALSE;
}
错误:You have an error in your syntax:check the manual that corresponds to your mysql server version for the right syntax to use near 'delimiter // create procedure sq_getundefinedcode(in ALD char(8),out retCode int' at line 1请这位仁兄帮忙解决一下,先谢过!
strSQL = "delimiter // create procedure sp_getundefinedcode(in AID char(8),out retCode int) proc: begin DECLARE v_workercode varchar(8);DECLARE v_stationcode varchar(8);DECLARE v_sitecode varchar(8);DECLARE v_eventcode varchar(8);DECLARE v_type char(2);SELECT sitecode INTO v_sitecode FROM TBL_SITE WHERE sitecode = AID;if !isnull(v_sitecode) then begin set retCode = 1;leave proc;end; end if;SELECT eventcode INTO v_eventcode FROM TBL_EVENT WHERE eventcode = AID;if !isnull(v_eventcode) then begin set retCode = 2;leave proc;end;end if;SELECT workercode INTO v_workercode FROM TBL_WORKER WHERE workercode = AID;if !isnull(v_workercode) then begin\
set retCode = 3;leave proc;end;end if;SELECT stationcode INTO v_stationcode FROM TBL_STATION WHERE stationcode = AID;\
if !isnull(v_stationcode) then begin set retCode = 4;leave proc;end;end if;set retCode = 0;end;// delimiter ;";
if(mysql_query(&mysql,(char*)(LPCTSTR)strSQL))
{
MessageBox(mysql_error(&mysql));
return FALSE;
}
错误:You have an error in your syntax:check the manual that corresponds to your mysql server version for the right syntax to use near 'delimiter // create procedure sq_getundefinedcode(in ALD char(8),out retCode int' at line 1 请这位仁兄帮忙解决一下,先谢过!