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.

GetSQLSelect with Dynamic Datawindows

4 posts in Appeon (partner product) Last posting was on 2008-05-28 18:10:40.0Z
Cindy Posted on 2008-05-23 13:18:23.0Z
Sender: 7642.4835cc6e.1804289383@sybase.com
From: Cindy
Newsgroups: sybase.public.appeon
Subject: GetSQLSelect with Dynamic Datawindows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4836c41f.186c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 May 2008 06:18:23 -0700
X-Trace: forums-1-dub 1211548703 10.22.241.41 (23 May 2008 06:18:23 -0700)
X-Original-Trace: 23 May 2008 06:18:23 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2119
Article PK: 21527

We are dynamically creating a datawindow, calling
SetTransObject for the datawindow (which returns a 1), then
calling GetSQLSelect. It is returning the Powerbuilder
Select statement (PBSelect) instead of the SQL Select
statement. We have installed the
install_appeon_syntaxfromsql_MSSQL.sql that is required for
dynamic Datawindows. Does anyone have any idea why we are
getting the PBSelect statement instead of the SQL Select
statement?
Thanks - Cindy


Chris Posted on 2008-05-23 15:32:38.0Z
From: Chris <cmetalic@gmail.com>
Newsgroups: sybase.public.appeon
Subject: Re: GetSQLSelect with Dynamic Datawindows
Date: Fri, 23 May 2008 08:32:38 -0700 (PDT)
Organization: http://groups.google.com
Lines: 24
Message-ID: <1daa5d62-85e4-49be-9645-195cc81b1ebd@f63g2000hsf.googlegroups.com>
References: <4836c41f.186c.1681692777@sybase.com>
NNTP-Posting-Host: 68.48.240.247
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1211556759 6784 127.0.0.1 (23 May 2008 15:32:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 23 May 2008 15:32:39 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f63g2000hsf.googlegroups.com; posting-host=68.48.240.247; posting-account=9m3qFAoAAACMZc-bJgOV727WMHBNHILK
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),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!f63g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2122
Article PK: 13291


On May 23, 9:18 am, Cindy wrote:
> We are dynamically creating a datawindow, calling
> SetTransObject for the datawindow (which returns a 1), then
> calling GetSQLSelect.  It is returning the Powerbuilder
> Select statement (PBSelect) instead of the SQL Select
> statement.  We have installed the
> install_appeon_syntaxfromsql_MSSQL.sql that is required for
> dynamic Datawindows.  Does anyone have any idea why we are
> getting the PBSelect statement instead of the SQL Select
> statement?
> Thanks - Cindy

Cindy, don't know if this will help or not, in my dynamic dws, I
usually build the entire SQL myself (ls_sql) and use SetSQLSelect to
define the query for the dw. The below code works for me.
GetSQLSelect returns the same pure SQL that I set, not PB-ized SQL. -
Chris

dw_reminder_result.SetTransObject(SQLCA)
dw_reminder_result.modify('DataWindow.Table.Select="'+ ls_sql+'"')
ll_return = dw_reminder_result.SetSQLSelect(ls_sql)
ls_sql = dw_reminder_result.getsqlselect()
//messagebox("sql",ls_sql)
ll_return = dw_reminder_result.Retrieve()


Cindy Posted on 2008-05-23 17:16:28.0Z
Sender: 7642.4835cc6e.1804289383@sybase.com
From: Cindy
Newsgroups: sybase.public.appeon
Subject: Re: GetSQLSelect with Dynamic Datawindows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4836fbec.1f55.1681692777@sybase.com>
References: <1daa5d62-85e4-49be-9645-195cc81b1ebd@f63g2000hsf.googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 May 2008 10:16:28 -0700
X-Trace: forums-1-dub 1211562988 10.22.241.41 (23 May 2008 10:16:28 -0700)
X-Original-Trace: 23 May 2008 10:16:28 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2124
Article PK: 21529


> On May 23, 9:18 am, Cindy wrote:
> > We are dynamically creating a datawindow, calling
> > SetTransObject for the datawindow (which returns a 1),
> > then calling GetSQLSelect.  It is returning the
> > Powerbuilder Select statement (PBSelect) instead of the
> > SQL Select statement.  We have installed the
> > install_appeon_syntaxfromsql_MSSQL.sql that is required
> > for dynamic Datawindows.  Does anyone have any idea
why
> > we are getting the PBSelect statement instead of the SQL
> > Select statement?
> > Thanks - Cindy
>
> Cindy, don't know if this will help or not, in my dynamic
> dws, I usually build the entire SQL myself (ls_sql) and
> use SetSQLSelect to define the query for the dw. The
> below code works for me. GetSQLSelect returns the same
> pure SQL that I set, not PB-ized SQL. - Chris
>
> dw_reminder_result.SetTransObject(SQLCA)
> dw_reminder_result.modify('DataWindow.Table.Select="'+
> ls_sql+'"') ll_return =
> dw_reminder_result.SetSQLSelect(ls_sql) ls_sql =
> dw_reminder_result.getsqlselect() //messagebox("sql"
> ,ls_sql) ll_return = dw_reminder_result.Retrieve()

Thanks for responding, Chris. In our case, the datawindow
is already built and we are modifying the Select statement
to add to the where clause so I need to get the existing
Select statement first.
Thanks - Cindy


Cindy Posted on 2008-05-28 18:10:40.0Z
Sender: dda.483d9e7e.1804289383@sybase.com
From: Cindy
Newsgroups: sybase.public.appeon
Subject: Re: GetSQLSelect with Dynamic Datawindows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <483da020.e46.1681692777@sybase.com>
References: <4836fbec.1f55.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 May 2008 11:10:40 -0700
X-Trace: forums-1-dub 1211998240 10.22.241.41 (28 May 2008 11:10:40 -0700)
X-Original-Trace: 28 May 2008 11:10:40 -0700, 10.22.241.41
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2138
Article PK: 21538


> > On May 23, 9:18 am, Cindy wrote:
> > > We are dynamically creating a datawindow, calling
> > > SetTransObject for the datawindow (which returns a 1),
> > > then calling GetSQLSelect.  It is returning the
> > > Powerbuilder Select statement (PBSelect) instead of
> > > the SQL Select statement.  We have installed the
> > > install_appeon_syntaxfromsql_MSSQL.sql that is
> > > required for dynamic Datawindows.  Does anyone have
> any idea why
> > > we are getting the PBSelect statement instead of the
> > > SQL Select statement?
> > > Thanks - Cindy
> >
> > Cindy, don't know if this will help or not, in my
> > dynamic dws, I usually build the entire SQL myself
> > (ls_sql) and use SetSQLSelect to define the query for
> > the dw. The below code works for me. GetSQLSelect
> > returns the same pure SQL that I set, not PB-ized SQL.
> - Chris >
> > dw_reminder_result.SetTransObject(SQLCA)
> > dw_reminder_result.modify('DataWindow.Table.Select="'+
> > ls_sql+'"') ll_return >
> dw_reminder_result.SetSQLSelect(ls_sql) ls_sql >
> > dw_reminder_result.getsqlselect() //messagebox("sql"
> ,ls_sql) ll_return = dw_reminder_result.Retrieve()
>
> Thanks for responding, Chris. In our case, the datawindow
> is already built and we are modifying the Select statement
> to add to the where clause so I need to get the existing
> Select statement first.
> Thanks - Cindy

Appeon support told me that "on the Web, if the datawindow
is dynamically created with SyntaxFromSQL, the return value
of GetSQLSelect on the Web is the same. However if the
datawindow is dynamically created with Describe
("Datawindow.syntax") and the data source of the datawindow
is PBSELECT, then on the Web the return value of
GetSQLSelect is the PBSelect. It is different from the
return value in PowerBuilder. And so far Appeon cannot
support this feature."

Cindy