Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Execute SQL query in debugging session

3 posts in General Discussion Last posting was on 2006-08-17 09:29:48.0Z
Laurent Posted on 2006-08-08 10:15:50.0Z
Sender: 405b.44d841ab.1804289383@sybase.com
From: Laurent
Newsgroups: sybase.public.workspace.general
Subject: Execute SQL query in debugging session
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44d86456.4141.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Aug 2006 03:15:50 -0700
X-Trace: forums-1-dub 1155032150 10.22.241.41 (8 Aug 2006 03:15:50 -0700)
X-Original-Trace: 8 Aug 2006 03:15:50 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:140
Article PK: 1087782

Hello,

Is there a way to execute a SQL query in the debbugging
session ?

For instance, I would like to check the content of a
temporary table.
I already seen that in "Referenced tables" view but I would
like to get specific lines.

Best regards,
Laurent


Samir Nigam Posted on 2006-08-16 21:11:02.0Z
From: "Samir Nigam" <Samir_N.O.S.P.A.M_Nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <44d86456.4141.1681692777@sybase.com>
Subject: Re: Execute SQL query in debugging session
Lines: 8443
MIME-Version: 1.0
Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_0025_01C6C13C.42ED8A20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
NNTP-Posting-Host: snigamxp.sybase.com
X-Original-NNTP-Posting-Host: snigamxp.sybase.com
Message-ID: <44e389e6@forums-1-dub>
Date: 16 Aug 2006 14:11:02 -0700
X-Trace: forums-1-dub 1155762662 10.22.85.194 (16 Aug 2006 14:11:02 -0700)
X-Original-Trace: 16 Aug 2006 14:11:02 -0700, snigamxp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:144
Article PK: 1087995

Laurent,
 
You can filter out the rows you want to see in the refereced tables view.
 
I have captured a screenshot here to show you how you can do it.  The screenshot shows the "up-arrow" towards the bottom of data grid in the Referenced Tables view. When you click there, you can specify where condition and order by columns. Besides this, you can set rowcount in the Window|Preferences|Sybase|Database Development|Sql Debugger page.
 
 
 
Hope this helps. Sorry about the delayed response.
 
Regards,
Samir
 
<Laurent> wrote in message news:44d86456.4141.1681692777@sybase.com...
> Hello,
>
> Is there a way to execute a SQL query in the debbugging
> session ?
>
> For instance, I would like to check the content of a
> temporary table.
> I already seen that in "Referenced tables" view but I would
> like to get specific lines.
>
> Best regards,
> Laurent

filter1.bmp