>Hi All,
>
>Could someone tell me the technology used in VFP as "SQL Pass-through" belongs to which terminology comparing with VB i.e. Data Access Objects, ODBCDirect, Remote Data Objects or ActiveX Data Objects?
>
SPT is used to issue commands to the back-end server, with VFP-style cursors used where data is exchanged. It corresponds to ODBC-level connections (although it may be talking to an OLEDB provider rather than an ODBC provider; it does not use an ADO-style COM object as the basis for data exchange or providing the ADO-style object model to manipulate.) SPT is the underlying basis for Remote Views on the VFP side, and can be used to issue SQL transactions to be executed by the server, including running stored procedures on the back-end. SPT is executed by the server for the connection rather than the local VFP engine.