🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Vdb variables in SQL statements

#1403
From: Tom Arnold
Date: Sun, 25 Jan 1998 00:00
41 lines
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-mail
References: <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