🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Why does this not work?

#665
From: Paul Franks
Date: Sun, 02 Aug 1998 00:00
28 lines
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-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 (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