Re: Use of variable for field name in sql filter

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

Article #1089

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

#1089

From: Jose Luis Perez Diez
Date: Wed, 29 Apr 1998 00:00

20 lines
1268 bytes

In article <35474aad.21911671@forums.borland.com>, Nedim Buyukmihci 
wrote:
> So, why isn't this nicely pointed out in online Help?
>
It is under filter:
"The criteria is in the form of a character string that contains an SQL 
expression,"
the expression Bowen wrote is the string
"Middle_name = 'b.'"
Yours where:
1 )form.rowset.filter := ["] + pctest + [= 'b.'"]
   ["Middle_name = 'b.'"]
2 & 3 if Middle_name when the assignment is done "E."     
form.rowset.filter := ["] + &pctest. + [= 'b.'"]
   ["E. = 'b.'"]
   form.rowset.filter := ["] + &pctest. + [= "] + 'b.'
   ["E.=" 'b.']
 
No SQL expression  at all <G>

Technical Details

Message-ID: <VA.000000a4.00599ef7@default>

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

References: <354612d7.7615375@forums.borland.com> <6i59h6$b8a3@forums.borland.com> <35474aad.21911671@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: Jose Luis Perez Diez <NOMAIL@Jluis.es>
Subject: Re: Use of variable for field name in sql filter
Date: 1998/04/29
Message-ID: <VA.000000a4.00599ef7@default>
X-Deja-AN: 348676358
Content-Transfer-Encoding: 8bit
References: <354612d7.7615375@forums.borland.com> <6i59h6$b8a3@forums.borland.com> <35474aad.21911671@forums.borland.com>
Mime-Version: 1.0
Reply-To: NOMAIL@Jluis.es
Content-Type: text/plain; charset=iso-8859-1
Organization: My Company
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message