Re: Memory variable in Where clause

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

Article #1257

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

#1257

From: George Shubin
Date: Fri, 20 Mar 1998 00:00

29 lines
1344 bytes

"David McCullough" <72223.2320@compuserve.com> wrote:

>>I have been trying to use a memory variable in a select * statement with  a
>>statement such as SELECT * FROM FEATURES  WHERE CODE = M->variable
>>Nothing I do seems to work. I hope a Visual Dbase ver. 7 for Dummies is
>>coming soon. I sure feel like one.


Try:
   
For character values:
	sql = "SELECT * FROM features WHERE code = '" + m-.variable + "'"

For numeric values:
	sql = "SELECT * FROM features WHERE code = " + STR(m-.variable)

Then:

	q = new Query()
	q.sql = sql 


 _________________________________________________________
 George Shubin                Custom Database Applications
 DX Software Systems                  Software Development
 Voice:  503/981-6806                   FAX:  503/982-0120
 E-mail: info@dxonline.com    Web: http://www.dxonline.com
 _________________________________________________________

Technical Details

Message-ID: <3512ab45.49414374@forums.borland.com>

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

References: <6eu59i$5jl3@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,dd0309f1a85fd8d3
X-Google-Attributes: gidff5a1,public
From: dx@canby.com (George Shubin)
Subject: Re: Memory variable in Where clause
Date: 1998/03/20
Message-ID: <3512ab45.49414374@forums.borland.com>
X-Deja-AN: 336011413
References: <6eu59i$5jl3@forums.borland.com>
Organization: DX Software Systems
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message