AnsweredAssumed Answered

SQL Request control don't display value?

Question asked by mreyesajila on Jul 11, 2016
Latest reply on Jul 28, 2016 by mreyesajila

I have a form and a SQL Request control to populate new secuencial from a corporate database

this es the transact-SQL Stored procedure

ALTER PROCEDURE [dbo].[GetNewSerie]
@Aplicacion nchar(10)
AS
BEGIN
SET NOCOUNT ON;
declare @secuencia int
declare @Prefijo nvarchar(20)
  Select @secuencia = Valor + 1, @Prefijo = Prefijo from Series where Secuencia = @Aplicación
update Series set Valor = @secuencia where Secuencia = @Aplicación
SELECT @Prefijo + convert(nvarchar(20), @secuencia, 105)
END

the SQL Request control work fine but, it does not show any value, when I view it in preview mode and after publishing the control appears empty

 

 

Mauricio Reyes

Outcomes