Re: Why does this not work?

Article View: borland.public.vdbase.data.sql

Article #807

Back to borland.public.vdbase.data.sql Previous Next

#807

From: Ken Mayer [TeamB]
Date: Wed, 22 Jul 1998 00:00

24 lines
1312 bytes

ncbuyukmihci@ucdavis.edu (Nedim Buyukmihci) wrote:

>VdB 7.01 (b1419), Win95
>
>If try to set a filter for a zipcode range in a program:
>
>  form.rowset.filter := "Zipcode >= '" + pcValue + "' and Zipcode <=
>'" + pcZipHigh + [']
>
>you get an error, no matter how the statement is set up (including
>using colons preceding the variables). The database engine does not
>seem to like the '>=' or '<=' symbols. Is there some other way to do
>this? I can use setRange() with the appropriate indexName, but there
>may be times when filtering like this would be helpful.

Turn the ">=" around to "=>" and see if that does the trick. The
darndest things can cause problems ...

KEn
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Technical Details

Message-ID: <35b52e28.1730928@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <35b5cc02.318528305@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,80b2a41f1ab93db
X-Google-Attributes: gidff5a1,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: Why does this not work?
Date: 1998/07/22
Message-ID: <35b52e28.1730928@forums.borland.com>
X-Deja-AN: 373680129
References: <35b5cc02.318528305@forums.inprise.com>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message