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.

DataWindow computed column syntax

4 posts in Appeon (partner product) Last posting was on 2012-02-20 07:54:53.0Z
Matthias Posted on 2012-02-13 12:33:41.0Z
From: "Matthias" <novalid@email.com>
Newsgroups: sybase.public.appeon
Subject: DataWindow computed column syntax
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3538.513
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3538.513
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f390325@forums-1-dub>
Date: 13 Feb 2012 04:33:41 -0800
X-Trace: forums-1-dub 1329136421 10.22.241.152 (13 Feb 2012 04:33:41 -0800)
X-Original-Trace: 13 Feb 2012 04:33:41 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2896
Article PK: 13643

Hi all,

I have a problem with many datawindows in my application!
If a datawindow include a computed column with the following syntax
"<columnname> <alias>" I get the message: "invalid columnname '<columnname>
<alias>'."

If I put the column name in brackets it works fine! But is there everywhere
a setting so that I can use the datawindows without change?

Regards,
Matthias


Chris Pollach Posted on 2012-02-15 13:21:20.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.appeon
References: <4f390325@forums-1-dub>
Subject: Re: DataWindow computed column syntax
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3bb150@forums-1-dub>
Date: 15 Feb 2012 05:21:20 -0800
X-Trace: forums-1-dub 1329312080 10.22.241.152 (15 Feb 2012 05:21:20 -0800)
X-Original-Trace: 15 Feb 2012 05:21:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2900
Article PK: 13647

Hi Matthias;

Can you tell us what DBMS & version you are using?

--
Regards ... Chris
President: STD Inc./ OSUG
VP ISUG - Membership
Blog: http://chrispollach.blogspot.com
PBDJ: http://chrispollach.sys-con.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"Matthias" <novalid@email.com> wrote in message
news:4f390325@forums-1-dub...
> Hi all,
>
> I have a problem with many datawindows in my application!
> If a datawindow include a computed column with the following syntax
> "<columnname> <alias>" I get the message: "invalid columnname
> '<columnname> <alias>'."
>
> If I put the column name in brackets it works fine! But is there
> everywhere a setting so that I can use the datawindows without change?
>
> Regards,
> Matthias


Matthias Posted on 2012-02-16 08:01:45.0Z
From: "Matthias" <novalid@email.com>
Newsgroups: sybase.public.appeon
References: <4f390325@forums-1-dub> <4f3bb150@forums-1-dub>
In-Reply-To: <4f3bb150@forums-1-dub>
Subject: Re: DataWindow computed column syntax
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3538.513
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3538.513
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3cb7e9@forums-1-dub>
Date: 16 Feb 2012 00:01:45 -0800
X-Trace: forums-1-dub 1329379305 10.22.241.152 (16 Feb 2012 00:01:45 -0800)
X-Original-Trace: 16 Feb 2012 00:01:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2902
Article PK: 13649

Hi Chris,

I use MSSQL Server 2008 with the native interface!


"Chris Pollach" schrieb im Newsbeitrag news:4f3bb150@forums-1-dub...

Hi Matthias;

Can you tell us what DBMS & version you are using?

--
Regards ... Chris
President: STD Inc./ OSUG
VP ISUG - Membership
Blog: http://chrispollach.blogspot.com
PBDJ: http://chrispollach.sys-con.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"Matthias" <novalid@email.com> wrote in message
news:4f390325@forums-1-dub...
> Hi all,
>
> I have a problem with many datawindows in my application!
> If a datawindow include a computed column with the following syntax
> "<columnname> <alias>" I get the message: "invalid columnname
> '<columnname> <alias>'."
>
> If I put the column name in brackets it works fine! But is there
> everywhere a setting so that I can use the datawindows without change?
>
> Regards,
> Matthias


Steven Posted on 2012-02-20 07:54:53.0Z
Sender: 3fea.4f419fbd.1804289383@sybase.com
From: steven
Newsgroups: sybase.public.appeon
Subject: Re: DataWindow computed column syntax
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f41fc4d.4f41.1681692777@sybase.com>
References: <4f3cb7e9@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Feb 2012 23:54:53 -0800
X-Trace: forums-1-dub 1329724493 172.20.134.41 (19 Feb 2012 23:54:53 -0800)
X-Original-Trace: 19 Feb 2012 23:54:53 -0800, 172.20.134.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2908
Article PK: 21941

Hi Matthias;
Could you provide the datawindow srd & table syntax to us?

Regards,
Steven