Lantica User Forum - XResultSetSearch and Boolean Fields

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › XResultSetSearch and Boolean Fields

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

XResultSetSearch and Boolean Fields (Read 733 times)

MP Full Member Offline Posts: 104 Joined: Sep 3^rd, 2007	XResultSetSearch and Boolean Fields Mar 11^th, 2008 at 3:04am	Print Post
	How do you construct an XResultSetSearch that searches for all Boolean values which are either False or Unknown? I tried /=1 but that returns an empty result set.


	IP Logged

Carl Underwood Senior Member Members Offline Posts: 1350 Location: New Hampshire Joined: Mar 11^th, 2003	Re: XResultSetSearch and Boolean Fields Reply #1 - Mar 11^th, 2008 at 5:09am	Print Post
	Have you tried "MyLE=<>1" or "MyLE=/1" ?

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

MP Full Member Offline Posts: 104 Joined: Sep 3^rd, 2007	Re: XResultSetSearch and Boolean Fields Reply #2 - Mar 11^th, 2008 at 11:05am	Print Post
	Quote: Have you tried "MyLE=<>1" or "MyLE=/1" ? Yes. EDIT: Sorry...cross-eyed...confused /= with =/. Thank you both Carl and Erika.
	« Last Edit: Mar 11^th, 2008 at 1:23pm by MP »

	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: XResultSetSearch and Boolean Fields Reply #3 - Mar 11^th, 2008 at 12:52pm	Print Post
	This works for me in the sample Customers database: Code vRS = @XResultSetSearch(@FN, "Customers", SEARCH_MODE_OR, SEARCH_SYNTAX_QA, "!Checked=/1")

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge