>Hi,
>
>When using VFP with SQL Server data and you have a ADODB connection object can it be used to path a SQL Select command using SPT approach?
>
>For example, say at the top of the app I have:
>
>

>oApp.oConn = createobject("adodb.connection")
>oApp.oConn.ConnectionString = [ConnectionString]
>oApp.oConn.Open()
>

>
>How can I use above later in the application in SQLEXE() command?
>
>TIA.

Like:

 cnnVFP = createobj("adodb.Connection")
    cnnVFP.Open ("Provider=VFPOLEDB.1;Data Source=C:\FoxPro_directory;Collating Sequence=MACHINE")  
    cnnVFP.Execute("set deleted off")		&&to get deleted records with VFPOLEDB.1
	o=cnnVFP.Execute("select SET('deleted') from some_table where RECNO()=1")
	?o.fileds(0).value
	o.close

All the Best