🚀 go-pugleaf

Romain Strieff [TeamB] wrote:

> >    SELECT sp_id, sp_name FROM covmgr.salesper salesper  WHERE
> >
> This stuff will always overwrite whatever is open at that time,
> perhaps
> that's where your problems come from?
> --

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.

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.

Thanks
--
Dan Barbaria
Printing Plant Supervisor
Omaha Public Schools
________________________________________________
Visit the "Unofficial Covalent ShopSystem Users Web Page" at:
www.top.net/barbaria