Finding the datasets connected to an ADOConnection
From: Dave Blake (barnswood_at_hotmail.com)
Date: 08/20/04
- Next message: Ivan Mjartan: "Ado and progress bar"
- Previous message: Brian Bushay TeamB: "Re: LRe: Expert: Sorting a DBGrid from an Access Db via ADO"
- Next in thread: Viatcheslav V. Vassiliev: "Re: Finding the datasets connected to an ADOConnection"
- Reply: Viatcheslav V. Vassiliev: "Re: Finding the datasets connected to an ADOConnection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 20 Aug 2004 09:15:54 +0100
What is the syntax for looping through all the datasets connected to an ADO
connection?
Having discovered that setting the ADOconnection.connected := false does not
close the datasets linked to it, and after say changing the connection
string and reconnecting, then subsequently dataset.open does not reopen
them properly... I want to loop through closing datasets before I mess with
the ADOconnection.
Mostly it is datasets that have accidentlally been saved with active = true
(because editing some data aware component in designing a report etc. has
silently opened it), and are thus loaded that way at runtime that worry me.
Change the connection at start-up, open datasets when needed, but if loaded
open already they don't work.
Dave (having a vague Friday)
- Next message: Ivan Mjartan: "Ado and progress bar"
- Previous message: Brian Bushay TeamB: "Re: LRe: Expert: Sorting a DBGrid from an Access Db via ADO"
- Next in thread: Viatcheslav V. Vassiliev: "Re: Finding the datasets connected to an ADOConnection"
- Reply: Viatcheslav V. Vassiliev: "Re: Finding the datasets connected to an ADOConnection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
