🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Select Statement & files open

#1153
From: Romain Strieff [TeamB]
Date: Tue, 21 Apr 1998 00:00
26 lines
1441 bytes
In article <353CD734.2C933D03@top.net>, barbaria@top.net grudgingly 
admits...
> Does a select statement open a file?
-----
Yes, unless it's only the SQL _property_ of a query object, then only the 
activating of the query does it.


> I've built an application that is basically an interface with an
> informix data base running on a host machine.  This application allows
> for order entry and writes to the informix tables.  Each order enrty
> requires several validation checks agaist tables on the host machine.
> This is done with select statements and checks agaist the results.
> After twenty or so order entries, I get an error that too many files are
> open.
-----
Can you show us a few lines of your code? Or at least a more complet 
descriptionof how and what you are doing?


-- 
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.fa6dd102e853b3298ac30@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <353CD734.2C933D03@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/21
Message-ID: <MPG.fa6dd102e853b3298ac30@forums.borland.com>
X-Deja-AN: 346330178
References: <353CD734.2C933D03@top.net>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql