Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Introduction to ADO Part 4 - Combining It All Expand / Collapse
Author
Message
Posted Sunday, November 25, 2001 12:00 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/introductiontoadopart4combiningitall.asp>http://www.sqlservercentral.com/columnists/awarren/introductiontoadopart4combiningitall.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1728
Posted Wednesday, December 5, 2001 4:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2002 12:00 AM
Points: 4, Visits: 1
Quite good !! Just as how filter is useful, so is the Clone method. But we have to remember to set the activeconnection to nothing and then clone the recordset else there will be umpteen problems




Post #24271
Posted Wednesday, December 5, 2001 4:57 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
The recordset is SOOOO powerful, lots of cool features that are seldom used. May try to explore more of these. Was also thinking of trying to show "why" and "how" a recordset works.

May I ask what got you interested in reading all the ado articles at once?


Andy


Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #24272
Posted Sunday, June 4, 2006 7:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 25, 2007 9:11 PM
Points: 1, Visits: 1

I have recently been reading your articals on ADO and have found them very useful. I tried your sample code for myself, but I get an error when setting the activeConnection property to nothing.

"Operation is not allowed when the object is open"

Can you help me on this.

Regards,

Ben

Post #284741
Posted Thursday, August 7, 2008 9:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 16, 2010 8:21 PM
Points: 22, Visits: 134
Hi Andy,

Hopefully you are still watching this old list!

I happened to find your 4 ADO articles after quite a bit of fumbling getting SQL to work from VBScript. They are a great help.

Could you advise whether this will work against an Ingres database?

In hope,
Paul
Post #548835
Posted Thursday, August 7, 2008 9:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 16, 2010 8:21 PM
Points: 22, Visits: 134
In addition to my last reply, what changes do we need to make to get this working in VBScript.

Paul
Post #548841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse