Article View: borland.public.vdbase.data.sql
Article #781Re: Multiple Alias '
From: Christopher F. Neumann
Date: Thu, 16 Jul 1998 00:00
Date: Thu, 16 Jul 1998 00:00
39 lines
1923 bytes
1923 bytes
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:
<6oljpv$9aa3@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com> <6ol4tl$8lm9@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: <6oljpv$9aa3@forums.borland.com> X-Deja-AN: 372113198 References: <6oj6el$71s5@forums.borland.com> <35ae4a1e.1154886@forums.borland.com> <6ol4tl$8lm9@forums.borland.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Organization: Physix, Inc. Newsgroups: borland.public.vdbase.data.sql