topic Re: comando executar in QlikView https://community.qlik.com/t5/QlikView/comando-executar/m-p/772856#M473439 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You have to check all check boxes in Setting sheet in bottom of script editor to Execute works.</P><P></P><P>Best regards.</P><P><IMG alt="SettingCheckBoxes.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70585_SettingCheckBoxes.png" style="width: 620px; height: 349px;" /></P></BODY></HTML> Wed, 05 Nov 2014 21:17:05 GMT 2014-11-05T21:17:05Z comando executar https://community.qlik.com/t5/QlikView/comando-executar/m-p/772854#M473437 <HTML><HEAD></HEAD><BODY><P>Bom dia!</P><P></P><P>estou precisando buscar informações do banco de dados através do comando executar dentro do banco de dados sql, o qual já faço algumas consultas.</P><P>precisei criar uma outra consulta nesse mesmo banco de dados, porém preciso do comando excutar.</P><P></P><P>verifiquei na pagina 132 do manual referencia, segui os paços em marcar as tres opção solicitadas, mesmo assim não deu certo</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">ao recarregar aparece uma mensagem de erro:</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Erro na linha do Scrip:</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">EXECUTE P_RC_CLI_FIDELI_PONTOS '2014-01-01','2014-11-05' </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">alguém pode me ajudar<BR /></SPAN></P></BODY></HTML> Wed, 05 Nov 2014 13:41:50 GMT https://community.qlik.com/t5/QlikView/comando-executar/m-p/772854#M473437 2014-11-05T13:41:50Z Re: comando executar https://community.qlik.com/t5/QlikView/comando-executar/m-p/772855#M473438 <HTML><HEAD></HEAD><BODY><P>maybe you forgot <STRONG>sql, </STRONG>this works on my sql server</P><P></P><P>T:</P><P>load *;</P><P><STRONG>sql</STRONG> execute sp_test '%E%';</P></BODY></HTML> Wed, 05 Nov 2014 20:43:15 GMT https://community.qlik.com/t5/QlikView/comando-executar/m-p/772855#M473438 maxgro 2014-11-05T20:43:15Z Re: comando executar https://community.qlik.com/t5/QlikView/comando-executar/m-p/772856#M473439 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You have to check all check boxes in Setting sheet in bottom of script editor to Execute works.</P><P></P><P>Best regards.</P><P><IMG alt="SettingCheckBoxes.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70585_SettingCheckBoxes.png" style="width: 620px; height: 349px;" /></P></BODY></HTML> Wed, 05 Nov 2014 21:17:05 GMT https://community.qlik.com/t5/QlikView/comando-executar/m-p/772856#M473439 2014-11-05T21:17:05Z Re: comando executar https://community.qlik.com/t5/QlikView/comando-executar/m-p/772857#M473440 <HTML><HEAD></HEAD><BODY><P>Bom dia, muito obrigado pela ajuda, deu tudo certo.</P><P></P><P>parabéns</P></BODY></HTML> Tue, 11 Nov 2014 11:07:29 GMT https://community.qlik.com/t5/QlikView/comando-executar/m-p/772857#M473440 2014-11-11T11:07:29Z Re: comando executar https://community.qlik.com/t5/QlikView/comando-executar/m-p/772858#M473441 <HTML><HEAD></HEAD><BODY><P>muito obrigado, perfeita a instrução</P></BODY></HTML> Tue, 11 Nov 2014 11:08:46 GMT https://community.qlik.com/t5/QlikView/comando-executar/m-p/772858#M473441 2014-11-11T11:08:46Z