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.

Question with Datawindow Select Statement on Appeon?

3 posts in Appeon (partner product) Last posting was on 2007-02-26 06:16:47.0Z
Vicky Posted on 2007-02-21 10:33:47.0Z
From: "Vicky" <vicky.yeung@gmail.com>
Newsgroups: sybase.public.appeon
Subject: Question with Datawindow Select Statement on Appeon?
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 210.177.225.148
X-Original-NNTP-Posting-Host: 210.177.225.148
Message-ID: <45dc200b@forums-1-dub>
Date: 21 Feb 2007 02:33:47 -0800
X-Trace: forums-1-dub 1172054027 210.177.225.148 (21 Feb 2007 02:33:47 -0800)
X-Original-Trace: 21 Feb 2007 02:33:47 -0800, 210.177.225.148
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1802
Article PK: 21370

Dear All,

I have a datawindow created with SQL statement like below:

SELECT table1.col1, table1.col2, table1.col3, table1.col4
FROM table1 LEFT OUTER JOIN table2 ON table1.col1 = table2.col1 --AND
table1.col2 = table2.col2
WHERE table1.col1 = 'aaa'
AND table1.col2 = 'TRY'
AND table2.col3 = 'TEST'

It works fine in client version and on Appeon 3.1, but not on Appeon 5.0.
Unless I remove the remarked sentences '--AND table1.col2 = table2.col2' and
deploy again, then it runs success.

Is that Appeon 5.0 will not support SQL contain remark sentences? or any
alternative way to fix it as i got couple of datawindows contained remark
sentences?

Many thanks in advance

System/Application Details:
PowerBuilder 10.2.1 Build 9696
Appeon 5.0 (Upgrade from Appeon 3.1)
MSSQL Server 2000

B.regards,
Vicky


Yang yongqing Posted on 2007-02-26 00:49:39.0Z
Sender: 30d2.45e22d94.1804289383@sybase.com
From: Yang yongqing
Newsgroups: sybase.public.appeon
Subject: Re: Question with Datawindow Select Statement on Appeon?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45e22ea3.30e2.1681692777@sybase.com>
References: <45dc200b@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Feb 2007 16:49:39 -0800
X-Trace: forums-1-dub 1172450979 10.22.241.41 (25 Feb 2007 16:49:39 -0800)
X-Original-Trace: 25 Feb 2007 16:49:39 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1809
Article PK: 21375

Hi Vicky,
Appeon 5.0 supports SQLs containing remark sentences. This
kind of issue sometimes occurs when you upgrade your
PowerBuilder version.
You can full build your application before deploying it. Or
save DataWindow source again (for example, by adjusting the
layout of the DataWindow, which enables the Save button).
Regards,
Yang yongqing


Vicky Posted on 2007-02-26 06:16:47.0Z
From: "Vicky" <vicky.yeung@gmail.com>
Newsgroups: sybase.public.appeon
References: <45dc200b@forums-1-dub> <45e22ea3.30e2.1681692777@sybase.com>
Subject: Re: Question with Datawindow Select Statement on Appeon?
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 210.177.225.148
X-Original-NNTP-Posting-Host: 210.177.225.148
Message-ID: <45e27b4f@forums-1-dub>
Date: 25 Feb 2007 22:16:47 -0800
X-Trace: forums-1-dub 1172470607 210.177.225.148 (25 Feb 2007 22:16:47 -0800)
X-Original-Trace: 25 Feb 2007 22:16:47 -0800, 210.177.225.148
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1815
Article PK: 21376

Dear Yang,

Thanks, I have full build my application and followed your instructions to
save the DataWindow source again, but found that if the remark sentence
using "/* */" it could run successful on Appeon 5.0, if using "--" symbol to
remark it, it would fail and return error. Is there any steps I have
missing??

many thanks,
Vicky

<Yang yongqing> wrote in message news:45e22ea3.30e2.1681692777@sybase.com...
> Hi Vicky,
> Appeon 5.0 supports SQLs containing remark sentences. This
> kind of issue sometimes occurs when you upgrade your
> PowerBuilder version.
> You can full build your application before deploying it. Or
> save DataWindow source again (for example, by adjusting the
> layout of the DataWindow, which enables the Save button).
> Regards,
> Yang yongqing