🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Filter on a Value

#904
From: Romain Strieff [TeamB]
Date: Sat, 27 Jun 1998 00:00
26 lines
1371 bytes
In article <3594d213.42845148@forums.inprise.com>, bradtech@bigpond.com 
grudgingly admits...
> 
> When I tried to set a filter based on a custom form property, it
> wouldn't work at all, just gave some weird error message. In the end I
> had to use Public variables in the filter statement and it worked
> fine.. I have come across other situations too where custom form
> properties can't be used.
> 
>  I guess there's plenty of life left yet in the old Public variables!
> 
PUBLICs are dead! The form could be open 25 times each with completely 
encapsulated queries and your PUBLIC variable would each time overwrite 
the filter of the other forms.

The filter property is just a string.
form.rowset.filter=[Name=']+aPrivateLocalVariable+[']
or
form.rowset.filter=[Name=']+form.someproperty+[']
or whatever



-- 
Romain Strieff [TeamB]
Technical Details
Message-ID: <MPG.ffef115d549923b98aeb8@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <359470a5.45211047@forums.borland.com> <3594d213.42845148@forums.inprise.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,9cc7a67ae9405e2d
X-Google-Attributes: gidff5a1,public
From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB])
Subject: Re: Filter on a Value
Date: 1998/06/27
Message-ID: <MPG.ffef115d549923b98aeb8@forums.borland.com>
X-Deja-AN: 366565709
References: <359470a5.45211047@forums.borland.com> <3594d213.42845148@forums.inprise.com>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql