Article View: borland.public.vdbase.data.sql
Article #1088Re: Select Statement & files open
From: Romain Strieff [TeamB]
Date: Wed, 29 Apr 1998 00:00
Date: Wed, 29 Apr 1998 00:00
23 lines
1474 bytes
1474 bytes
In article <35466179.65E93F68@top.net>, barbaria@top.net grudgingly admits... > I don't understand what you mean. > > I understand that the Select statement makes the SQL query the 'active' > table. In my code I close the table with a "Close Table" command after > I'm done with the data collected. ----- Yes, but in which workarea? > The problem is without these Select statements the application is not > workable. If they are the cause of the too many files open, is there a > way to close the files when the number of files nears the too many? > Apparently the Close Table command doesn't close the file. ------ Sorry, never used SQL other than in a query object. -- Romain Strieff [TeamB] Want quick help? Check previous Q and A at: http://forumsearch.borland.com:88/ and TIs at http://www.borland.com/VdBASE/vdbprod.html
Technical Details
Message-ID:
<MPG.fb0d8ba7bc387c598ac6b@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<353CD734.2C933D03@top.net> <MPG.fa6dd102e853b3298ac30@forums.borland.com> <353E0C49.3B6EB3F0@top.net> <MPG.fae32cd55c01cc598ac37@forums.borland.com> <35466179.65E93F68@top.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,1db6d06459b7da87 X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: Select Statement & files open Date: 1998/04/29 Message-ID: <MPG.fb0d8ba7bc387c598ac6b@forums.borland.com> X-Deja-AN: 348660317 References: <353CD734.2C933D03@top.net> <MPG.fa6dd102e853b3298ac30@forums.borland.com> <353E0C49.3B6EB3F0@top.net> <MPG.fae32cd55c01cc598ac37@forums.borland.com> <35466179.65E93F68@top.net> Organization: TeamB Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql