Hi Aleksey,

Did you also find that this doesn't work in VFP9?
Or is there a new better way of doing.

Sorry For Bringing up an old thread I just came across it in looking for a solution to my problem..

TIA
Tim

>There is an easier way to pass parameters using CursorAdapter, it handles parameters similar to SPT.
>
>

>CLOSE DATABASES ALL
>CLEAR
>
>customerid='ALFKI'
>
>LOCAL oCA as CursorAdapter
>
>oCA=CREATEOBJECT("CursorAdapter")
>oCA.SelectCmd="select * from Northwind..Orders where customerID = ?m.customerid"
>
>?"ODBC"
>oCA.DataSourceType="ODBC"
>oCA.DataSource=SQLCONNECT("localServer")
>
>IF oCA.DataSource<1
>	?"Failed to connect."
>ELSE
>	?oCA.CursorFill()
>	LIST
>	USE
>	SQLDISCONNECT(oCA.DataSource)
>ENDIF
>
>?
>?"ADO"
>
>LOCAL oConn as ADODB.Connection, oRS as ADODB.Recordset, oCom as ADODB.Command
>
>oConn=CREATEOBJECT("ADODB.Connection")
>oConn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=(local)")
>
>oRS = CREATEOBJECT("Adodb.RecordSet")
>oRS.ActiveConnection = oConn
>
>oCom = CREATEOBJECT("Adodb.Command")
>oCom.ActiveConnection = oConn
>
>oCA.DataSourceType="ADO"
>oCA.DataSource=oRS
>
>?oCA.CursorFill(,,,oCom)
>LIST
>USE
>

>
>Thanks,
>Aleksey.