🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Set Filter

#1239
From: Bowen Moursund
Date: Mon, 16 Mar 1998 00:00
14 lines
1011 bytes
>d.applyfilter(d.fields["FSTYLE"].value=left(f.fields["HDSTYLE"].value,3))

Filter expressions must be SQL expressions. SQL don' know nuttin' 'bout no
VdB field objects <g>. Try something like this:

 d.filter = 'FSTYLE = '+left(f.fields["HDSTYLE"].value,3)
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm
Try these help resources:
http://forumsearch.borland.com:88
http://www.dejanews.com/home_ps.shtml
Technical Details
Message-ID: <6ek2aa$oeo3@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <350D5224.67F2D870@ionline.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b86967b852917692
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: Set Filter
Date: 1998/03/16
Message-ID: <6ek2aa$oeo3@forums.borland.com>
X-Deja-AN: 334655153
Content-Transfer-Encoding: 7bit
References: <350D5224.67F2D870@ionline.net>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql