Re: Multiple Alias '

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

Article #810

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

#810

From: Romain Strieff [TeamB]
Date: Wed, 22 Jul 1998 00:00

29 lines
1585 bytes

In article <6ovn3u$hmr8@forums.borland.com>, CNeumann@Physix.com 
grudgingly admits...
> I would expect 50 select's of MTABLE!  If I use the code that only accesses
> VdB tables, the problem does NOT occur.  If I use the code that only
> accesses the SQL tables, the problem does NOT occur.  If I instanciate the
> VdB tables and later in the program select an SQL table, THE PROBLEM OCCURS!
> 
> >Or do I miss something?
------
Mmm, wild guess, did you try to select them with the database identifier?

use :theAlias:clients in select()
use orders in select()
etc
> 
> 
> DOH!
> 
> >If you you want to start afresh, just CLOSE DATABASES before opening any
> tables.
> 
> All VdB tables are instanciated on initial execution.  SQL tables are
> opened/closed as needed, primarily due to a VdB limitation of ONLY 1 SQL
> table open at a time, whether or not opened as an alias.
---------
Really? Where did you read that? 

-- 
Romain Strieff [TeamB]

Technical Details

Message-ID: <MPG.101fa992a77a9c898afe8@forums.borland.com>

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

References:

<6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com> <6ol4tl$8lm9@forums.borland.com> <MPG.101d0516c55331cd98afdb@forums.borland.com> <6ovn3u$hmr8@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,c34fa95eb77b2a9a
X-Google-Attributes: gidff5a1,public
From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB])
Subject: Re: Multiple Alias '
Date: 1998/07/22
Message-ID: <MPG.101fa992a77a9c898afe8@forums.borland.com>
X-Deja-AN: 373789109
References: <6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com> <6ol4tl$8lm9@forums.borland.com> <MPG.101d0516c55331cd98afdb@forums.borland.com> <6ovn3u$hmr8@forums.borland.com>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message