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.

Query Mode

2 posts in DataWindow Last posting was on 2009-11-02 14:33:20.0Z
rc Posted on 2009-11-01 18:02:19.0Z
From: "rc" <rcarrier@innsoftinc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Query Mode
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aedcd2b$1@forums-1-dub>
Date: 1 Nov 2009 10:02:19 -0800
X-Trace: forums-1-dub 1257098539 10.22.241.152 (1 Nov 2009 10:02:19 -0800)
X-Original-Trace: 1 Nov 2009 10:02:19 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90189
Article PK: 409793

Does anyone know how to enter NOT IN ('2020', '2010) in query mode. The
IN ('2020','2010') works as expected.

Thanks,
Richard


AJ Posted on 2009-11-02 14:33:20.0Z
Sender: 5431.4aeeece6.1804289383@sybase.com
From: Aj
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Query Mode
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4aeeedb0.5458.1681692777@sybase.com>
References: <4aedcd2b$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Nov 2009 06:33:20 -0800
X-Trace: forums-1-dub 1257172400 10.22.241.41 (2 Nov 2009 06:33:20 -0800)
X-Original-Trace: 2 Nov 2009 06:33:20 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90194
Article PK: 409799


> Does anyone know how to enter NOT IN ('2020', '2010)
> in query mode. The IN ('2020','2010') works as expected.
>
> Thanks,
> Richard
>
>

Use sqlpreview to do this trick. First make sure to not to
extend the sqlpreview from the ancestor. Then, just set the
sqlsyntax in sqlpreview to the query you define as in the
following:
sqlsyntax = ls_syntax
this.setsqlpreview(sqlsyntax)
CALL SUPER::sqlpreview
Where ls_syntax is the syntax you define.

Hth.