Article View: borland.public.vdbase.data.sql
Article #801Why does this not work?
From: Nedim Buyukmihci
Date: Tue, 21 Jul 1998 00:00
Date: Tue, 21 Jul 1998 00:00
14 lines
1033 bytes
1033 bytes
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. Ned
Technical Details
Message-ID:
<35b5cc02.318528305@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,80b2a41f1ab93db,start X-Google-Attributes: gidff5a1,public From: ncbuyukmihci@ucdavis.edu (Nedim Buyukmihci) Subject: Why does this not work? Date: 1998/07/21 Message-ID: <35b5cc02.318528305@forums.inprise.com> X-Deja-AN: 373560363 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Organization: PigByte DataοΏ½ Mime-Version: 1.0 Reply-To: ncbuyukmihci@ucdavis.edu Newsgroups: borland.public.vdbase.data.sql