Hello i have a problem with my system of CRM called Onyx
-
Hello how are you?, i hope that you are fine, well friends , let me explain my problem with my system that i am working, my company decided to migrate to a web version, it version has a problem to print out the messages of TSQL, the System Onyx is designed to print out the print that it found in the tsql code of SP. for example print 'Hello', Onyx displayes the print into a messagesbox , but the new web version has a problem, when it find a select before of a print, the prints are not displayed into the messagesbox, i think that the Onyx is confused when find a select, the selects and the prints displayes messages,but by a strange reason, when appears the selects, the prints are not consideres,but it must consider the prints and not the selects, the selects must not be displayed only the prints must be , some friend would like to explain the difference between the selects and the prints? , the Onyx crashes with them, the new Version of Onyx is made in asp, it uses ADO to connect to a sqlserver2000, i can not to modify the dll that Onyx uses, i am to trying to seek some command of tsql that can help me, some set or something?, some friend can help me to tell me some ideas that i can to try them?????
Thanks a lot of sorry my bad english , i am practicing it.
PD : i am refering the selects like select 'Hello world'
select * from MYTable
select 'nice to meet you' , the select like select @name = 'Hector' doesnt give problem.
-
It sounds like you need to call ONYX for support.
To answer your question about SELECT vs. PRINT. SELECT returns a record set to the client (unless it is being used in its assignment role i.e. SELECT @variableName = <some value>
but PRINT returns a message to the client. Messages need to be handled differently than record sets./*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
Hector while I am not sure what the problem is here a select statement can return more than one row. The select statements you indicate are not causing a problem can return only one row.
Mike
-
Yes it sounds to call Onyx, but while i am to trying understand what the dll does to distinct the difference between and select and a print,friend you told that the select returns a recordset, this recordset is stored in some place???
Friend if you have to build a dll that displayes the prints but not the selects, how will you distinct the prints and select stamments???? how do you build a dll like that?
thanks master...
-
The data is stored in your database
IF Object_ID('tempdb..test') >0
DROP TABLE Test
CREATE TABLE Test
(
SomeData varchar(20)
)
INSERT INTO Test VALUES('A')
INSERT INTO Test VALUES('B')
INSERT INTO Test VALUES('C')
INSERT INTO Test VALUES('D')
Select * from Test
/*
Returns 4 rows
A
B
C
D
*/
DECLARE @var varchar(20)
SET @var='A'
select @var
/*
Returns
A
*/
Just as a thought try this select statement
SELECT SomeData FROM Test WHERE SOMEDATA = 'A'
Mike
-
I dont unterstand what do you mean ??? i know that , i need to find if exists some flag with the execution of a select that i can to turn off for avoiding the select will be consider in the display of information.....
for example select 'hello'
it displayes hello
i want that hello will be not display in the queryanalizer, exist some set to do that??? i know if i use the set nocount on , the result of count of row are not display in the screen, exits some similar for the select will be not display???
thank you...
-
The Web version (and possibly the normal app) would be using ADO.
Every SELECT statement creates a RecordSet in ADO, and these are entirely different objects to messages (PRINT).
One way that you can understand how these are different is in SQL Server Query Analyser. Set Query Analyser to display results in a grid. When you run a query that returns both SELECT result sets, and PRINTs you will see two tabs in the result panel. The left tab (Grids) will show what ADO captures as a RecordSet. The right tab (Messages) shows what ADO will capture as server info.
It's up to Onyx on how these two different bits of information are handled, so I'd suggest calling their support.
Julian Kuiters
juliankuiters.id.au
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply