Article View: borland.public.vdbase.data.sql
Article #1403Re: Vdb variables in SQL statements
From: Tom Arnold
Date: Sun, 25 Jan 1998 00:00
Date: Sun, 25 Jan 1998 00:00
41 lines
2014 bytes
2014 bytes
Romain Strieff [TeamB] wrote:
>
> In article <34CA5957.6338@inna.net>, tarnold@inna.net grudgingly
> admits...
> >
> > this.rowset = this.aircraft1.rowset
> >
> > function form_onOpen
> > u = new UpdateSet()
> > u.source = form.aircraft1.rowset
> > foo = funique('Temp????.dbf')
> > u.destination = foo
> > u.copy()
> > msgbox(foo+' Exists? - '+file(foo))
> > with (form.QUERY1)
> > sql = 'SELECT * FROM foo'
> > active = true // error here
> > endwith
> > msgbox("Done")
> > return
> > endclass
> >
> Mmm, sure they is not there? If I understand the mechanism the copy will
> be created in the FLEET database directory.
Actually not true. The copy is created in the working ( .WFM )
directory. The FD creates Query1 with the database directory property
set to the fleet database, but I have tried it both ways, neither work,
but the created files does not go to the fleet database. As I said
before, use an explicit character name for foo, and this code works, but
as soon as a variable is used, it doesn't. I had jumped to the
conclusion that I just don't know how to insert foo into the SQL
statement in a manner that the BDE will recognize, and that was the
reason for my first post.
--
Tom
Bena, VA
To reply email, please remove the KILL.SPAM from my address. Not
necessary for NGs
Technical Details
Message-ID:
<34CB8D8D.486F@inna.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<34CA5957.6338@inna.net> <MPG.f35302984656db98a54d@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,55c42f16f0b042e2 X-Google-Attributes: gidff5a1,public From: Tom Arnold <tarnold@inna.net> Subject: Re: Vdb variables in SQL statements Date: 1998/01/25 Message-ID: <34CB8D8D.486F@inna.net> X-Deja-AN: 319165037 Content-Transfer-Encoding: 7bit References: <34CA5957.6338@inna.net> <MPG.f35302984656db98a54d@forums.borland.com> Content-Type: text/plain; charset=us-ascii Organization: Microaid Mime-Version: 1.0 Reply-To: KILL.SPAM.tarnold@inna.net Newsgroups: borland.public.vdbase.data.sql