MS SQL and the Cancel on RecordSet/Command

From: Martijn Tonies (m.tonies_at_upscene!nospam!.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 18:00:56 +0200

Hi all,

I've been playing around with some a-synchronus executing
and fetching of data... In general, this works for a bit - now,
if I would like to cancel while fetching I call the
RecordSet.Cancel method - this cancels fetching and closes
the recordset, but apparently, the memory that was used for
retrieving the data doesn't get free-ed.

If I re-run the query, my apps continues eathing memory instead
of using the old memory first...

Any idea what's going on? Does this actually work? 

-- 
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Relevant Pages