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.

M-Biz Anywhere 5.5 DB Search

2 posts in General Discussion Last posting was on 2004-08-24 22:23:57.0Z
Matthew Mamet Posted on 2004-08-24 13:52:49.0Z
Sender: 7f7a.4117bea2.1804289383@sybase.com
From: Matthew Mamet
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: M-Biz Anywhere 5.5 DB Search
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <412b499e.2d1d.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 24 Aug 2004 06:58:54 -0700, 10.22.241.42
Lines: 12
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2004 06:42:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2004 06:52:49 -0700
X-Trace: forums-1-dub 1093355569 10.22.108.75 (24 Aug 2004 06:52:49 -0700)
X-Original-Trace: 24 Aug 2004 06:52:49 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:155
Article PK: 8744

Does the AGDBSearch object provide support for the SQL "in"
statement? Such as: Select * from myTable where id in
(1,5,9,43)

judging from the help files, it doesn't look to be true,
just thought i'd double check.

the help file specifically states support for the AND
operator, but what about the OR operator? i could accomplish
the same task using OR statements in my where clause . . .

thx


Yadong Liu Posted on 2004-08-24 22:23:57.0Z
Sender: 566b.411c0d3b.1804289383@sybase.com
From: Yadong Liu
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: M-Biz Anywhere 5.5 DB Search
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <412bbffd.2f86.1681692777@sybase.com>
References: <412b499e.2d1d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Aug 2004 15:23:57 -0700
X-Trace: forums-1-dub 1093386237 10.22.241.41 (24 Aug 2004 15:23:57 -0700)
X-Original-Trace: 24 Aug 2004 15:23:57 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:157
Article PK: 17599

AGDBSearch does not have support for the SQL "in" clause. It
also only supports "and" but not "or".

For full SQL support, you may want to take a look at
UltraLite included in SQL Anywhere Studio
http://www.ianywhere.com/promos/dev_edition/index.html. In
future releases, I expect that there will be better
integration between UltraLite and XMLDB.

> Does the AGDBSearch object provide support for the SQL
> "in" statement? Such as: Select * from myTable where id in
> (1,5,9,43)
>
> judging from the help files, it doesn't look to be true,
> just thought i'd double check.
>
> the help file specifically states support for the AND
> operator, but what about the OR operator? i could
> accomplish the same task using OR statements in my where
> clause . . .
>
> thx