Query from DC_AdsStatement leaving files open

SqlQuery is a library and utility program that utilizes the best features of Xbase++ and eXpress++ for SQL browsing of data via ADSDBE, PGDBE and ODBCDBE.
Post Reply
Message
Author
User avatar
Tim K
Posts: 51
Joined: Thu Jun 03, 2010 3:55 pm

Query from DC_AdsStatement leaving files open

#1 Post by Tim K »

I'm using a query using DC_AdsStatement that does a SELECT INTO a file which works great except the files selected from and created remain open, but not as open work areas. How do I release these files? Is DROP TABLE the proper way or is will that restrict future use?

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Query from DC_AdsStatement leaving files open

#2 Post by rdonnay »

You should use oAdsStatement:close() when you are finished with a work area that contains a SQL Cursor.

This will insure that Ads statement handles are closed on the server and also any data files associated with the cursor.
The eXpress train is coming - and it has more cars.

User avatar
Tim K
Posts: 51
Joined: Thu Jun 03, 2010 3:55 pm

Re: Query from DC_AdsStatement leaving files open

#3 Post by Tim K »

That's what I was missing. Thanks.

Post Reply