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.

Subselect containing retrieval arguments

3 posts in DataWindow .NET Last posting was on 2004-11-09 15:13:11.0Z
Leonard Berman Posted on 2004-11-08 21:04:08.0Z
Reply-To: "Leonard Berman" <leonard.berman@surecomp-usa.com>
From: "Leonard Berman" <leonard.berman@surecomp-usa.com>
Newsgroups: sybase.public.datawindow.net
Subject: Subselect containing retrieval arguments
Lines: 16
Organization: Surecomp Services
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 66.155.166.50
X-Original-NNTP-Posting-Host: 66.155.166.50
Message-ID: <418fdf48@forums-1-dub>
Date: 8 Nov 2004 13:04:08 -0800
X-Trace: forums-1-dub 1099947848 66.155.166.50 (8 Nov 2004 13:04:08 -0800)
X-Original-Trace: 8 Nov 2004 13:04:08 -0800, 66.155.166.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:674
Article PK: 125105

We have a datawindow whose query contains a subselect with a retrieval
argument. We are connecting to a Microsoft SQL Server database using an ODBC
driver. We successfully built the datawindow a couple of years ago when
running PowerBuilder 7. Now that we have upgraded to PowerBuilder 9, we have
observed that query fails unless we set Disable Bind to 1. First, why is
this necessary? Secondly, is the Disable Bind requirement related to the
PowerBuilder upgrade or to a newer ODBC driver? If it is related to
PowerBuilder, is there a fix?

Thanks.

Regards,

Leonard Berman


Jim O'Neil [Sybase] Posted on 2004-11-08 22:24:39.0Z
From: "Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com>
Newsgroups: sybase.public.datawindow.net
Subject: Re: Subselect containing retrieval arguments
Message-ID: <desvo0dr52odsvm6l8a9hju669vmq4k2g8@4ax.com>
References: <418fdf48@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: joneilw2k.sybase.com
X-Original-NNTP-Posting-Host: joneilw2k.sybase.com
Date: 8 Nov 2004 14:24:39 -0800
X-Trace: forums-1-dub 1099952679 10.18.43.140 (8 Nov 2004 14:24:39 -0800)
X-Original-Trace: 8 Nov 2004 14:24:39 -0800, joneilw2k.sybase.com
Lines: 26
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:675
Article PK: 125101

I believe it's due to a limitation in the Microsoft ODBC driver, was
the PB 7 app also using ODBC or was it using the native driver.

BTW, post followups to thi son the
sybase.public.powerbuilder.datawindow newsgroup. This forum is
specifically for DataWindow .NET.

On 8 Nov 2004 13:04:08 -0800, "Leonard Berman"

<leonard.berman@surecomp-usa.com> wrote:

>We have a datawindow whose query contains a subselect with a retrieval
>argument. We are connecting to a Microsoft SQL Server database using an ODBC
>driver. We successfully built the datawindow a couple of years ago when
>running PowerBuilder 7. Now that we have upgraded to PowerBuilder 9, we have
>observed that query fails unless we set Disable Bind to 1. First, why is
>this necessary? Secondly, is the Disable Bind requirement related to the
>PowerBuilder upgrade or to a newer ODBC driver? If it is related to
>PowerBuilder, is there a fix?
>
>Thanks.
>
>Regards,
>
>Leonard Berman
>


Leonard Berman Posted on 2004-11-09 15:13:11.0Z
Reply-To: "Leonard Berman" <leonard.berman@surecomp-usa.com>
From: "Leonard Berman" <leonard.berman@surecomp-usa.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <418fdf48@forums-1-dub> <desvo0dr52odsvm6l8a9hju669vmq4k2g8@4ax.com>
Subject: Re: Subselect containing retrieval arguments
Lines: 37
Organization: Surecomp Services
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 66.155.166.50
X-Original-NNTP-Posting-Host: 66.155.166.50
Message-ID: <4190de87$1@forums-1-dub>
Date: 9 Nov 2004 07:13:11 -0800
X-Trace: forums-1-dub 1100013191 66.155.166.50 (9 Nov 2004 07:13:11 -0800)
X-Original-Trace: 9 Nov 2004 07:13:11 -0800, 66.155.166.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:72103
Article PK: 393483

The PB7 application was also using ODBC.

Leonard

"Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com> wrote in message
news:desvo0dr52odsvm6l8a9hju669vmq4k2g8@4ax.com...
> I believe it's due to a limitation in the Microsoft ODBC driver, was
> the PB 7 app also using ODBC or was it using the native driver.
>
> BTW, post followups to thi son the
> sybase.public.powerbuilder.datawindow newsgroup. This forum is
> specifically for DataWindow .NET.
>
> On 8 Nov 2004 13:04:08 -0800, "Leonard Berman"
> <leonard.berman@surecomp-usa.com> wrote:
>
> >We have a datawindow whose query contains a subselect with a retrieval
> >argument. We are connecting to a Microsoft SQL Server database using an
ODBC
> >driver. We successfully built the datawindow a couple of years ago when
> >running PowerBuilder 7. Now that we have upgraded to PowerBuilder 9, we
have
> >observed that query fails unless we set Disable Bind to 1. First, why is
> >this necessary? Secondly, is the Disable Bind requirement related to the
> >PowerBuilder upgrade or to a newer ODBC driver? If it is related to
> >PowerBuilder, is there a fix?
> >
> >Thanks.
> >
> >Regards,
> >
> >Leonard Berman
> >
>