Article View: borland.public.vdbase.data.sql
Article #782Re: Multiple Alias '
From: John Williamson
Date: Thu, 16 Jul 1998 00:00
Date: Thu, 16 Jul 1998 00:00
54 lines
2221 bytes
2221 bytes
You Mean Inprise don't you?
Christopher F. Neumann <CNeumann@Physix.com> wrote in article
<6oljpv$9aa3@forums.borland.com>...
> Another entry in the BORLAND's MONSTROUS BOOK OF VdB WORKAROUNDS!
>
> do while .t.
> if select("mytable") > 0
> use in MYTABLE
> else
> exit
> endif
> enddo
>
>
> Christopher F. Neumann wrote in message
<6ol4tl$8lm9@forums.borland.com>...
> >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:
<01bdb0ff$0175fa60$1f6186cc@default>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com> <6ol4tl$8lm9@forums.borland.com> <6oljpv$9aa3@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: "John Williamson" <datam@rt66.com> Subject: Re: Multiple Alias ' Date: 1998/07/16 Message-ID: <01bdb0ff$0175fa60$1f6186cc@default> X-Deja-AN: 372147689 Content-Transfer-Encoding: 7bit References: <6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com> <6ol4tl$8lm9@forums.borland.com> <6oljpv$9aa3@forums.borland.com> Content-Type: text/plain; charset=ISO-8859-1 Organization: DataMaster Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql