Re: Filter on a Value

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

Article #903

Back to borland.public.vdbase.data.sql Previous Next

#903

From: Romain Strieff [TeamB]
Date: Sat, 27 Jun 1998 00:00

26 lines
1038 bytes

In article <359470a5.45211047@forums.borland.com>, tgp@compuserve.com 
grudgingly admits...
> --->The following filter (being a constant) works fine.
> --->But what would the syntax be if I wanted to filter
> --->based on the value of "AnyForm.Cusnum.Value."
> 
>       filter = "tcusnum=1" 
> 
>    endwith
> 
The filter property is a string, not a command, just build it with 
whatever you have.

       n=1
       filter = [tcusnum=]+ltrim(str(n))

   
or

    filter = [Name=']+trim(form.entryfield1.value)+[']

etc

-- 
Romain Strieff [TeamB]

Technical Details

Message-ID: <MPG.ffef07793c29ed698aeb7@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <359470a5.45211047@forums.borland.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.ffef07793c29ed698aeb7@forums.borland.com>
X-Deja-AN: 366565708
References: <359470a5.45211047@forums.borland.com>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message