>
>ADO in newer technology, but it does not make cursor, and you should use data RecordSet. Personally I prefer to use ODBC connection, because the result of my queries is FoxPro cursor and I can handle it using all FoxPro features and in addition to that I can write select statements to join these cursors as native FoxPro tables.Venelina,
Probably you haven't tried the OLEDB library (file #
10002). It returns the SQL query result into VFP cursor, and you can combine new ADO/OLEDB technology and all Foxpro features. This library replaces almost all SPT functions with OLEDB analogs. The disadvantages of this library (compared with SPT) are: 1) Parameterized queries are currently not supported (simply I haven't time to implement it); and 2) the resulting cursor cannot be made updateable using CURSORSETPROP().