Article View: borland.public.vdbase.data.sql
Article #470Re: VARIABLE PATH IN THE SQL
From: Lawrence J. Lee
Date: Thu, 03 Dec 1998 00:00
Date: Thu, 03 Dec 1998 00:00
23 lines
1329 bytes
1329 bytes
On Mon, 30 Nov 1998 14:15:58 +0800, "Geoff S. Wass" <gswass@ibm.net>
wrote:
>" select * from [&mpath]\itemf.dbf"
>would become:
>" select * from " + mpath + "\itemf.dbf"
>[ select * from "] + mpath + [\itemf.dbf"]
>
Thank you Geoff. It works fine. and now pretty better understand
using the strings here.
For another thing, Not sure to post here or to the form group.
As long as I "modify command this.wfm" the sql remaims same.
But those source codes are permanently changed to "select * from
\\pos1\e\sys\itemf.dbf" when I "modify form this.wfm. It has only one
time of life with the variable path. I need to keep the original
code "select * from " +mpath + "\item.dbf" in the form.
*****************************
Lawrence Lee
ab6oj@pacificnet.net
**************************
Technical Details
Message-ID:
<366711db.26330214@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<36622949.50148114@forums.inprise.com> <3662381E.19A01421@ibm.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,dc1e185199e9f1db X-Google-Attributes: gidff5a1,public From: ab6oj@pacificnet.net (Lawrence J. Lee) Subject: Re: VARIABLE PATH IN THE SQL Date: 1998/12/03 Message-ID: <366711db.26330214@forums.inprise.com> X-Deja-AN: 418402698 References: <36622949.50148114@forums.inprise.com> <3662381E.19A01421@ibm.net> Organization: Another Netscape Collabra Server User Reply-To: ab6oj@pacificnet.net Newsgroups: borland.public.vdbase.data.sql