June 10, 2005 at 9:08 am
Hello , i have a strange problem with a web interface, this interface has dll, that show me the result of select like a popup ,and i dont want that occurs , so to solve it i must to comment all selects of SPs because i cant modify the dll, i think that this dll read the recordset of the selects and then it print them like a popup..... friends, is possible to hide the result of select ???? for example wiht a flag like a set ...something..???
thank you....
June 10, 2005 at 9:13 am
You can't hide it without causing the dll to fail...
You could try to rename the sps to see what happens.
You could modify the select statements and add a Where 1 = 0 so that now rows are returned. But I guess the popup would still pop.
What's this dll doing?
Is it part of your application... Is there a way not to call it?
June 10, 2005 at 9:28 am
Hello, sorry my bad english , this dll is sick with the selects, the dll must to display in the webinterface the print messages like ( print ' Wellcome our System') but when exists a select like ( select 'Hello' ) the dll crashed, it thinks that the select are prints and it displayes the results of select too, well it is a hard work to check all the select of 1023 sp of my system , i dont know what the dll does to display the results of selects? i think that read some recordset of sql??? is possible to avoid that the selects will generate recordsets? with some flag like a set nocount on???
exists some 'set nodisplay on' or something samely ????
Thanks... i hope that you understand me...
June 10, 2005 at 9:32 am
SET NOCOUNT on would surely help for print statements.. but you'd still have to know in which sp to put it.
Can you fire up the profiler and run the page(s) that cause that dll to execute?
Then you'd know which proc to modify.
June 10, 2005 at 9:44 am
Well that dll is sick, but i think better to build a new dll, i need to build a dll to show me the prints of sp , do you know how to get the prints using ADOBD?????
Thankssss
June 10, 2005 at 9:48 am
I think that the prints are returned as error messages in .net. But I'm not sure of that.
I agree that it would be best to fix the dll than to try to undermind it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply