YU

i have absolutely no idea why cannot add hyperlink shape if trigged in-cell function. when run manually immediate window, working well. don't have troubles doing manually. i have no idea how write error handling in vba this sample code. function testcase(xllabelname string) dim sht worksheet each sht in activeworkbook.sheets if shapeexist(sht, xllabelname) sht.hyperlinks.add anchor:=sht.shapes(xllabelname), address:="", subaddress:="a1" testcase = "bingo" end if next sht end function from immediate window bingo answer , in cell #arg! error , line not executed. tried ungroup shapes first using dim gshp shape dim shrng shaperange dim tmp string set gshp = sht.shapes(getparentshape(xllabelname)) tmp = gshp.name set shrng = gshp.ungroup sht.hyperlinks.add anchor:=sht.shapes(xllabelname), address:="", subaddress:="a1" shrng.regroup shrng.name = tmp but failed. , still im

i using angular ionic. i not want user have login again in case logged in , did not logout last time used application. reason, using local storage check if user logged in. tried putting code in run block. $rootscope.$on('$statechangestart', function (event, tostate, toparams, fromstate, fromparams) { if($localstorage.userinfo){ $state.go('deployment'); //this line 270 of app.js event.preventdefault(); return; } }) but gives error says: rangeerror: maximum call stack size exceeded @ scope.$broadcast (ionic.bundle.js:23414) @ object.transitionto (ionic.bundle.js:40804) @ object.go (ionic.bundle.js:40671) @ app.js:270 @ scope.$broadcast (ionic.bundle.js:23412) @ object.transitionto (ionic.bundle.js:40804) @ object.go (ionic.bundle.js:40671) @ app.js:270 @ scope.$broadcast (ionic.bundle.js:23412) @ object.transitionto (ionic.bundle.js:40804) also, error: [$rootscope

can please me in solving this. need keep latest 3 months records in table. table structure: after purge table should try this: delete tablex inner join (select max(insertdt ) lastdate, id tablex group id) lastdates on lastdates.id = tablex.id insertdt < dateadd(m,-3,lastdates.lastdate)

i writing program countries around world. i want add feature user add own country, modifying source code. this current source code written in python 3.0.1: # -*- coding: utf-8 -*- print "bem vindo um programa educativo sobre os variados paises mundo, creado por tomas simoes, 2015" contry = raw_input("qual e o pais que desejas visitar? - ") if contry == "afeganistao": print "o que desejas saber sobre o/a", contry,"?" print "1 - cultura" print "2 - linguagem" print "3 - historia" print "4 - localizacao" contry_spec = raw_input(" : ") if contry_spec == "1": print "nao sei muito sobre cultura do/a", contry,",desculpa!" elif contry_spec == "2": print "a linguagem do/a", contry,"e pachto e dari." elif contry_spec == "3": print "nao sei muito sobr

we facing issues while analyzing .net projects using sonarqube 5.1.1. please note fxcop rules enabled @ quality profile level. we using msbuild sonarqube runner analyze projects. facing error says sonar.cs.fxcop.assembly must set. we have faced similar issue sonar-runner-2.4 @ time parameter can passed sonar-project.properties file. but sonar-runner not support .net projects, using msbuild sonarqube runner now. could kindly confirm how can avoid these issues msbuild sonarqube runner , execute fxcop rules on .net projects? c# plugin version 4.1. please let me know if further information needed our end. we have postponed our production sonar upgrade due issue project teams not ok disabling fxcop rules @ quality profile level. kindly in fixing this. thanks, sri priyanka i thinks should read http://www.sonarqube.org/easy-analysis-of-visual-studio-solutions-with-the-sonarqube-scanner-for-msbuild/ , http://docs.sonarqube.org/display/plug/c%23+plugin . pay

how initialize ptype2 copy ptype3 struct (type-conversion)? typedef struct ptype2 { double x, y; ptype2() : x(0), y(0) {} ptype2(const ptype3 & ptype3) : x(ptype3.x), y(ptype3.y) {} //abort ptype3.z create two-dimensional point ptype2(double xy) : x(xy), y(xy) {} ptype2(double x, double y) : x(x), y(y) {} } ptype2; output: error c2065: 'ptype3' : undeclared identifier error c2143: syntax error : missing ',' before '&' error c2228: left of '.a' must have class/struct/union error c2228: left of '.b' must have class/struct/union error c2664: 'ptype2::ptype2(const ptype2 &)' : cannot convert argument 1 'ptype3' 'const int' error c4430: missing type specifier - int assumed. note: c++ not support default-int i have 2 typedef struct , ptype2(double x, double y) , ptype3(double x, double y, double z) . an assignment operator overloading solve problem? the compiler can'