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 Appeon (partner product) Last posting was on 2004-07-29 06:25:37.0Z
Allen Posted on 2004-07-28 20:16:25.0Z
Reply-To: "Allen" <yin5915@ms5.hinet.net>
From: "Allen" <yin5915@ms5.hinet.net>
Newsgroups: sybase.public.appeon
Subject: query mode
Lines: 4
Organization: yi
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
NNTP-Posting-Host: kh210-202-31-42.vdsl.static.apol.com.tw
X-Original-NNTP-Posting-Host: kh210-202-31-42.vdsl.static.apol.com.tw
Message-ID: <41080999$1@forums-1-dub>
Date: 28 Jul 2004 13:16:25 -0700
X-Trace: forums-1-dub 1091045785 210.202.31.42 (28 Jul 2004 13:16:25 -0700)
X-Original-Trace: 28 Jul 2004 13:16:25 -0700, kh210-202-31-42.vdsl.static.apol.com.tw
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:353
Article PK: 20705

Hi
query mode can support in appeon ??


Julie Jiang Posted on 2004-07-29 06:25:37.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <41080999$1@forums-1-dub>
Subject: Re: query mode
Lines: 125
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0CF5_01C47577.3C6B27B0"
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
X-Original-NNTP-Posting-Host: 61.144.207.174
Message-ID: <4108996d@forums-2-dub>
X-Original-Trace: 28 Jul 2004 23:30:05 -0700, 61.144.207.174
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Jul 2004 23:18:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Jul 2004 23:25:37 -0700
X-Trace: forums-1-dub 1091082337 10.22.108.75 (28 Jul 2004 23:25:37 -0700)
X-Original-Trace: 28 Jul 2004 23:25:37 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:354
Article PK: 20703

Hi Allen,

It depends on how you want to do the query.

1) Querying by setting the QueryMode to true is unsupported.

2) Using either of the following two methods is supported:

Method #1: popping up a Query window
STEP 1: Add a Query button.  At the click of the Query button, a Query window pops up.
STEP 2: The user inputs query criteria in the Query window.
STEP 3: After clicking Ok in the Query window, the current DataWindow only displays the desired data.
(Recommended) Method #2: entering Query criteria in the DataWindow directly and then querying.  This method is easier to apply since Appeon engineer has designed an of_query function for it (as attached.  Change the file extension to .txt to view the content).
STEP 1: Define an of_query function.  Copy the content in the attached of_query function.txt as the syntax for the function.
STEP 2: Place a Query button beside the DataWindow.  In the Clicked event of the Query button, add syntax similar to the following:
dw_1.reset()
   for i=1 to n
   dw_1.insertrow(0)
   next
of_query(dw_1)   //call to the of_query function
 
There is a limitation with this method however: the operators such as <, >, =, >=, <=, <>, LIKE, IN, AND, and OR, can be recognized only in columns of Char, Date and Time data type.  For other columns, the only operator that can be used for querying is "=".
 
Regards,
Julie Jiang
Appeon Corporation



"Allen" <yin5915@ms5.hinet.net> wrote in message news:41080999$1@forums-1-dub...
> Hi
>    query mode can support in appeon ??
>
>