declaring variable inside mysql stored procedure -

-

we trying declare variable inside mysql stored procedure has transaction implemented in it. seems giving syntax error :

following syntax of stored procedure:

create procedure `sp_markappointmentrefferal`(   p_appid bigint,   p_newlocation bigint,   p_userid bigint,   p_referralreason varchar(500),   p_newlocationname varchar(100) ) begin   declare v_oldlocation int default 0; set v_oldlocation = (select locationid appointments iappid = p_appid limit 1 );   declare exit handler sqlexception      begin         rollback;         select -1;     end;     start transaction;         update table set is_referred = 1,  referred_timestamp = now(),   referral_reason = p_referralreason  iappid = p_appid  limit 1;    -- create new appointment new referred location..    insert appointments   (vappname, vapptype, dappdate, vcell, ipatid, iappstatus, iuserid, iactive,    dinsertdate, ihsid, daily_ticket_no, locationid, visit_id, encounter_id, referredfrom,referredopdname, opd_name )      select vappname, vapptype, now(), vcell, ipatid, iappstatus, p_userid,      1, now(), ihsid, fn_generatenextappointmentticket(now(),p_newlocation) , p_newlocation, visit_id, encounter_id+1,      (select locationid appointments iappid = p_appid limit 1),     (select opd_name appointments iappid = p_appid limit 1), p_newlocationname     appointments     iappid = p_appid limit 1;      select last_insert_id();  commit;    end;

the syntax checker saying declare command not valid here. have tried place inside transaction clause , similar error shows ..

any appreciated..

all declare statements should @ top of stored procedure body. moving declare exit handler before set statement should fix problem.


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more