JVP wrote an good paper on ADO. You can find it at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp?frame=true

For the CursorAdapter, see the CoDe Focus issue on VFP 8. See http://www.code-magazine.com/focus/Article.aspx?quickid=0301062


>Hi Craig. Thanks for clearing that up.
>
>I just need to know something. In my current code using ODBC and SQLSTRINGCONNECT i get a connection - oConn
>
>Now to use SPT I use:
>SQLEXEC(oConn,[My SPT statement],'MyReturnCursor')
>
>which is very simple in syntax to use.
>
>How dows this translate to ADO/OLEDB where you have to create a recordset object etc.
>
>All I need is:
>1. establish a connection
>2. Use that connection EASILY to return me a cursor or to execute a stored proc
>3.Use CursorAdapters to Update tables.
>
>I have been doing this in ODBC and it is pretty easy. How does this translate to ADO?
>
>TIA
>
>