🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Why does this not work?

#817
From: Ken Mayer [TeamB]
Date: Thu, 23 Jul 1998 00:00
30 lines
1412 bytes
ncbuyukmihci@ucdavis.edu (Nedim Buyukmihci) wrote:

>I had already tried that (even though => was not supposed to be
>correct for sql) with no success, but I tried it again and still get
>the 'Operation not applicable' error.

Well, it was a thought. I always forget which way those things go. The
little details will mess you up in the weirdest ways sometimes. That
said ... does:

  form.rowset.filter := [Zipcode >= '] + pcValue + [']

Work?

If so, then try:

  form.rowset.filter := [Zipcode <= '] + pcZipHigh + [']

If that works, there's something really odd happening. 

Wait -- is the zipcode field a numeric or a character value?  That
could, of course, really mess things up ...


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: <35b67db5.1634630@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35b5cc02.318528305@forums.inprise.com> <35b52e28.1730928@forums.borland.com> <35b601bf.633897@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/23
Message-ID: <35b67db5.1634630@forums.borland.com>
X-Deja-AN: 374017039
References: <35b5cc02.318528305@forums.inprise.com> <35b52e28.1730928@forums.borland.com> <35b601bf.633897@forums.inprise.com>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql