cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

SQL Request control don't display value?

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

Labels: (3)
0 Kudos
Reply
4 Replies
shrinivasnaik
Nintex Newbie

Re: SQL Request control don't display value?

Hi Mauricio,

Is it ExecuteSQL Control you are referring to?

Shrini

0 Kudos
Reply
Not applicable

Re: SQL Request control don't display value?

it is design mode form

diseño.png

config1.png

here is SQL request control configuration with Test query result

config.png

in run time mode, befor new form the counter is 16 and after is 16 but, SQL Request control does not show value

result.png

Reply
shrinivasnaik
Nintex Newbie

Re: SQL Request control don't display value?

HI Mauricio,

Apologies I havent had SQL request control on my version of Nintex ( I am using Enterprise edition but we havent yet upgraded to the latest version, so cant really comment. I guess there must be other members who would have access to this control and can help you troubleshoot,

Regards,

Shrini

0 Kudos
Reply
Not applicable

Re: SQL Request control don't display value?

Problem solved, I used an alias in the SQL query and use the same alias in the fields "Value field" and "Display field"

thanks all

0 Kudos
Reply