Article View: borland.public.vdbase.data.sql
Article #199Re: creating tables
From: Jens Korth
Date: Wed, 06 Jan 1999 00:00
Date: Wed, 06 Jan 1999 00:00
24 lines
1228 bytes
1228 bytes
> I suggest you use the system temp directory for temporary tables. You can
> determine the temp directory with GETENV(). Maybe something like this:
>
> private cTmpTable
> cTmpTable = getenv("TMP") + "\" + "TMP.DBF"
> create table &cTmpTable. ( STOCK CHAR(5), .........
>
>>Another wicked solution... don't understand why I never thought about
>>that..d'oh!
Yes, it's a good idea, but it seems not to work.
I just tried it.
The problem ist the : which is a part of the directory string.
Let's say cTmpTable is "y:\tmp\tmp.dbf"
Create table &ctmptable gives error message "Database Error, Invalid use of
keyword, :\tmp\tmp.dbf"
Any solution?
--
Jens Korth
Technical Details
Message-ID:
<76vg8t$d1c2@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<36905D71.848AE379@netfront.net> <76r3k9$8vp6@forums.borland.com> <3692C197.770A2600@netfront.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e4cce62cc4a643dc X-Google-Attributes: gidff5a1,public From: "Jens Korth" <Jens@wanadoo.fr> Subject: Re: creating tables Date: 1999/01/06 Message-ID: <76vg8t$d1c2@forums.borland.com> X-Deja-AN: 429365577 References: <36905D71.848AE379@netfront.net> <76r3k9$8vp6@forums.borland.com> <3692C197.770A2600@netfront.net> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql