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.

retrievel arguments in sqlpreview or GetSqlSelect

2 posts in DataWindow Last posting was on 2008-06-05 10:00:17.0Z
lorenzo777 Posted on 2008-06-05 08:41:33.0Z
From: lorenzo777 <lorenzo.petralia@telenet.be>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: retrievel arguments in sqlpreview or GetSqlSelect
Date: Thu, 5 Jun 2008 01:41:33 -0700 (PDT)
Organization: http://groups.google.com
Lines: 20
Message-ID: <a7b28d25-c631-41be-80cd-802563bbb6cd@y38g2000hsy.googlegroups.com>
NNTP-Posting-Host: 81.246.118.4
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1212655294 4366 127.0.0.1 (5 Jun 2008 08:41:34 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 Jun 2008 08:41:34 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y38g2000hsy.googlegroups.com; posting-host=81.246.118.4; posting-account=j-lTTwoAAAA2zA7bFUH4mOJbAmvFaQ_t
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!y38g2000hsy.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87084
Article PK: 416342

Hello is there any way to the sql slect statement back when using a DW
with a retrieval argument WITH the actual value of the argument

Example:

now i get :

where name:= as_name

i would like to get

where name = 'actual value'

I tried with datawindow.table.slect , with GetSqlSelect and with the
arguments in the sqlpreview window.

i'm using oracle 10 and powerbuilder 10.5


Thanx


Chris Werner Posted on 2008-06-05 10:00:17.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <a7b28d25-c631-41be-80cd-802563bbb6cd@y38g2000hsy.googlegroups.com>
Subject: Re: retrievel arguments in sqlpreview or GetSqlSelect
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4847b931$1@forums-1-dub>
Date: 5 Jun 2008 03:00:17 -0700
X-Trace: forums-1-dub 1212660017 10.22.241.152 (5 Jun 2008 03:00:17 -0700)
X-Original-Trace: 5 Jun 2008 03:00:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87085
Article PK: 416341

Hi,

use disablebind=1

"lorenzo777" <lorenzo.petralia@telenet.be> schrieb im Newsbeitrag
news:a7b28d25-c631-41be-80cd-802563bbb6cd@y38g2000hsy.googlegroups.com...

> Hello is there any way to the sql slect statement back when using a DW
> with a retrieval argument WITH the actual value of the argument
>
> Example:
>
> now i get :
>
> where name:= as_name
>
> i would like to get
>
> where name = 'actual value'
>
> I tried with datawindow.table.slect , with GetSqlSelect and with the
> arguments in the sqlpreview window.
>
> i'm using oracle 10 and powerbuilder 10.5
>
>
> Thanx