Example to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)

pcsoft.us.windevCopyright 2026, PC SOFT3 Feb 2017 14:46:59 Z8 Jan 2015 17:29:57 ZExample to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery) CODIGO MSSQL: [code:sql] --PEGA O VALOR DA ULTIMA CORRIDA USE [producao] GO CREATE PROCEDURE NG0002_Procedure_UltimaCorrida AS DECLARE @num_corrida int; SELECT @num_corrida = num_ultima_numera FROM numeracao WHERE ide_numera = 'ACT263_CORRIDA' AND num_ano_refere = year(getdate()); SELECT @num_corrida AS num_corrida; return @num_corrida; GO [/code] CODIGO NO WINDEV, WEBDEV - USO EM WEBSERVICE: //Executar procedure [code:wl] numero_corrida is int = 0 MyProcedureUltimaCorrida is Data Source IF HExecuteSQLQuery(MyProcedureUltimaCorrida, ConnNativa, hQueryWithoutCorrection,"NG0002_Procedure_UltimaCorrida") THEN HReadFirst(MyProcedureUltimaCorrida, num_corrida) WHILE HOut() = False ok = HReadNext(MyProcedureUltimaCorrida, num_corrida) numero_corrida = MyProcedureUltimaCorrida.num_corrida END ELSE Error(HErrorInfo()) END Trace(numero_corrida) [/code] Veio valor sem dar erro no Trace()30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev/read.awpExample to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)moderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Bollerpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-60651/read.awp3 Feb 2017 14:46:59 ZExemplo [code:wl] PROCEDURE Existdatabase(TOKEN, CNPJ) ok is boolean = False Resultado, Msg is string = "" IF TOKEN…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-60651/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-60651/read.awpExample to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)Re: Example to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)Bollerpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-49799/read.awp8 Jan 2015 17:33:26 ZInformação adicional http://doc.windev.com/en-US/?5515009&productversion=XXA150056Mhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-49799/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-49799/read.awpExample to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)Re: Example to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)Bollerpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-49798/read.awp8 Jan 2015 17:30:09 Z:merci:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-49798/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49797-example-run-sql-stored-procedure-with-windev-webdev-49798/read.awpExample to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)Re: Example to Run an MS SQL Stored Procedure with Windev, Webdev using HExecuteSQLQuery (Exemplo para Executar uma MS SQL Stored Procedure com o Windev, Webdev usando o HExecuteSQLQuery)