Article View: borland.public.vdbase.data.sql
Article #665Re: Why does this not work?
From: Paul Franks
Date: Sun, 02 Aug 1998 00:00
Date: Sun, 02 Aug 1998 00:00
28 lines
1394 bytes
1394 bytes
Reading this thread again, there are several questions not yet asked. 1. Does it work if you substitute literal values? .filter := Zipcode >= "1234" and Zipcode <= "2345" 2. Does the filter expression convert to a valid Select expression which can be applied to a table from command window for testing? 3. If no-go as a select statement, does it work with literals? I'll support the suggestion of debugger, if only to see if what you think is happening is really the case. Strange things like variables going out of scope can show like this. In article <35b5cc02.318528305@forums.inprise.com>, ncbuyukmihci@ucdavis.edu says... > 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. > -- Paul Franks (TeamB)
Technical Details
Message-ID:
<MPG.102e50ccabc4c8bf98987e@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<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 (Paul Franks) Subject: Re: Why does this not work? Date: 1998/08/02 Message-ID: <MPG.102e50ccabc4c8bf98987e@forums.inprise.com> X-Deja-AN: 377257100 References: <35b5cc02.318528305@forums.inprise.com> Organization: TeamB Newsgroups: borland.public.vdbase.data.sql