[dba-SQLServer] ADO

Thank you Francisco and Marty
Excellent - Thanks for the Help file tip Marty

Saved again by the list

See y'all

DD

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
MartyConnelly
Sent: Tuesday, 27 September 2005 2:30 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] ADO

You should get the MDAC SDK  ADO help files ado260.chm Available from
downloads area at http:\\www.microsoft.com/data maybe available on WinXP by
default so check first.
Not sure if there are higher help versions for MDAC 2.8 or uses same name.

It Installs to here, I then create a desktop shortcut C:\Program
Files\Microsoft Data Access SDK\Docs\ado260.chm

Open up tree menus ADOProgrammersReference-->ADO API reference
                               --> ADO Code Examples --> Visual Basic
Examples

Methods Code examples

AddNew Method Example
Append and CreateParameter Methods Example AppendChunk and GetChunk Methods
Example BeginTrans, CommitTrans, and RollbackTrans Methods Example Cancel
Method Example Clone Method Example CompareBookmarks Method Example
ConvertToString Method Example CopyRecord, CopyTo, and SaveToFile Methods
Example CreateRecordset Method Example Delete Method Example DeleteRecord
and MoveRecord Methods Example Execute, Requery, and Clear Methods Example
Find Method Example GetRows Method Example GetString Method Example

or this one not as useful for vba unless working with SQL Sever from SQL BOL
download C:\Program Files\Microsoft SQL Server Books Online\1033\adosql.chm

Francisco Tapia wrote:

>Daren,
>With ado, you can insert a new row item by using the .ADDNEW method...
>examples can be found here:
>http://devguru.com/technologies/ado/8669.asp
>
>more on ADO...
>http://devguru.com/technologies/ado/home.asp
>
>
>
>On 9/25/05, Darren DICK <darrend at crhorizons.com.au> wrote:
>  
>
>>Hi All
>>Can someone give me a quick rundown on the INSERT andUPDATE abilities 
>>using ADO I vaguely remember the differences between ADO and DAO 
>>INSERT and UPDATE etc were substantial
>>
>>Many thanks
>>
>>Darren
>>
>>_______________________________________________
>>dba-SQLServer mailing list
>>dba-SQLServer at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>>http://www.databaseadvisors.com
>>
>>
>>    
>>
>
>
>--
>-Francisco
>http://pcthis.blogspot.com |PC news with out the jargon!
>http://sqlthis.blogspot.com | Tsql and More...
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>

--
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com