Off-line data set

Article View: borland.public.cppbuilder.database.ado

Article #1335

Back to borland.public.cppbuilder.database.ado Previous Next

#1335

From: Paul Cheetham
Date: Sun, 29 Aug 2004 15:59

25 lines
1455 bytes

Hi,

I am using a TADOStoredProc component to call a stored procedure on an 
MS SQL server and return a data set.
I was expecting the dataset to be returned and held in memory, meaning I 
could close the connection, and then read the data as required.

It seems though, that if I close the connection, my data goes with it!
I have tried creating a new dataset (TCustomADODataSet) and using the 
Clone function - I expected this to copy the data but it appears not to.

Can anyone tell me if it is possible to copy a datset into memory in 
some way, as it makes things so much neater.


Thankyou.



-- 
Paul Cheetham

"There are 10 types of people in the world - those that understand 
Binary, and those that don't."

Technical Details

Message-ID: <MPG.1b9c0dd99db2ead2989691@Newsgroups.Borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,69a8ce37eaf4aef6,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Paul Cheetham <PAC.News@dsl.pipex.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Off-line data set
Date: Sun, 29 Aug 2004 16:59:54 +0100
Message-ID: <MPG.1b9c0dd99db2ead2989691@Newsgroups.Borland.com>
Organization: None
X-Newsreader: MicroPlanet Gravity v2.50
NNTP-Posting-Host: 81.86.138.235
X-Trace: newsgroups.borland.com 1093795181 81.86.138.235 (29 Aug 2004 08:59:41 -0700)
Lines: 25
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail