Article View: borland.public.vdbase.data.sql
Article #1085Re: Use of variable for field name in sql filter
From: Bowen Moursund
Date: Tue, 28 Apr 1998 00:00
Date: Tue, 28 Apr 1998 00:00
16 lines
1093 bytes
1093 bytes
>then, any of these three results in "middle_name undefined"
> form.rowset.filter := ["] + pctest + [= 'b.'"]
> form.rowset.filter := ["] + &pctest. + [= 'b.'"]
> form.rowset.filter := ["] + &pctest. + [= "] + 'b.'
You're overdelimiting <g>. Try it like this:
form.rowset.filter = pctest + [= 'b.']
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://lonestar.texas.net/~moursund/
Try these help resources:
http://forumsearch.borland.com:88
http://www.dejanews.com/home_ps.shtml
Technical Details
Message-ID:
<6i59h6$b8a3@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<354612d7.7615375@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,c246b502811359c7 X-Google-Attributes: gidff5a1,public From: "Bowen Moursund" <teamb@opto-pps.com> Subject: Re: Use of variable for field name in sql filter Date: 1998/04/28 Message-ID: <6i59h6$b8a3@forums.borland.com> X-Deja-AN: 348503660 Content-Transfer-Encoding: 7bit References: <354612d7.7615375@forums.borland.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Organization: DataTech Newsgroups: borland.public.vdbase.data.sql