>>oConn = CREATEOBJECT("ADODB.Connection")
>>oConn.Open("
Connection string")
>>
>>ors=createobject("adodb.recordset")
>>ors.activeconnection=oconn
>>
>>ors.open("select * from company")
>>
>>aRecords = ors.getrows() &&
This populates the array with all the records in the record set>>
>>*The odd array that creates is that it brings all the items in the first field first, then all the items in the second field and so forth. In VFP, normally items stored in an array are brought on a record by record basis.
>>
>>
>>It sounds weird, but this is what's happening right now. DO you have any idea on how to bring records from a SQL table without using a dbc?
>
>If you insist on using ADO, you can use VFPCOM, which will install as a COM server, which can convert between recordsets and cursors directly; I believe that Rick Strahl also has a utility with similar functionality at his Web site. You can download VFPCOM from msdn.microsoft.com/vfoxpro
Thanks Ed
For every bug fixed, there is a bigger bug not yet discovered.