Happy New Year!! I wish you the best, all of you guys!
Thank you very much for your suggestions . Let me apologize, nowadays I’ve been some kind of crazy with some activities here in my work, because of the end of year and start of year…
And yeah, the drop down list returns an integer.
Well, when I change the value in the drop down list, it changes the query and the query executes.
At this point, “I meausure” the time just by viewing the table, when the table’s values changes I notice that the table is updated. I don’t know how could I measure this time… well I figure out, maybe with a timer using “table’s properties loading” or something.
I’m thinking in some configuration in gateway related to number of connections for the DB for get fast response from SQL Server, but I can’t remember where is, what do you think?
And the code is:
SELECT Descripcion, Trim,
WHEN Trim > 100 THEN '> 100'
WHEN Trim < 100 THEN '< 100'
WHEN Trim = 100 THEN '= 100'
END AS 'EdoTrim',
Add_ON, VReal AS Real,
WHEN VReal < Obj_PSD THEN '<'
WHEN VReal > Obj_PSD THEN '>'
WHEN VReal = Obj_PSD THEN '='
END AS Estado,
Obj_PSD AS PSD, Obj_TLX AS TLX
FROM adhesivos_cons_PE08(6) -- this is the integer returned by the dropdown list
Thank you very much!!