Re: Multiple Alias '

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

Article #780

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

#780

From: Christopher F. Neumann
Date: Thu, 16 Jul 1998 00:00

27 lines
1589 bytes

When it is first selected, I do a LIST STAT and I see 3 seperate selects.
When I do a USE IN MYTABLE, it removes 1 and keeps the other 2.  When I run
the routine again, I have 4 left after it is done.  I use VdB tables & MS
SQL tables.  I use the following scenario:

**using VdB tables
set database to MYSQLTABLES
**using SQL tables
set database to
**using VdB tables
(etc.)

If I just use the SQL routine, there is no problem.  If I just use the VdB
routine, there is no problem.  When I use the above scenario to get the use
of ALL of my tables (VdB & SQL), I have the problem.

Gary (Gary White) wrote in message <35ae4a1e.1154886@forums.borland.com>...
>On Wed, 15 Jul 1998 16:26:56 -0500, "Christopher F. Neumann"
><CNeumann@Physix.com> shared these words of wisdom:
>
>> In the following, I only select the alias PATENC once!!  Can someone
explain
>> WHY I get so many alias' from only one USE IN SELE()
>
>Looks like it's being called several times without begin closed in
>between.  You might try running it in the debugger to see what's
>happening.

Technical Details

Message-ID: <6ol4tl$8lm9@forums.borland.com>

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

References: <6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@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: "Christopher F. Neumann" <CNeumann@Physix.com>
Subject: Re: Multiple Alias '
Date: 1998/07/16
Message-ID: <6ol4tl$8lm9@forums.borland.com>
X-Deja-AN: 372040611
References: <6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Physix, Inc.
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message