bb.donnay-software.com

Donnay Software Web Forums
It is currently Sun Sep 15, 2019 2:59 pm

All times are UTC - 7 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Tue Jun 11, 2019 9:30 am 
Offline
User avatar

Joined: Thu Jun 03, 2010 3:55 pm
Posts: 50
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?


Top
 Profile  
 
PostPosted: Wed Jun 12, 2019 5:58 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 3975
Location: Boise, Idaho USA
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.


Top
 Profile  
 
PostPosted: Wed Jun 12, 2019 2:07 pm 
Offline
User avatar

Joined: Thu Jun 03, 2010 3:55 pm
Posts: 50
That's what I was missing. Thanks.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group