>>Is it possible to set the RecordSource property of a grid to a ADO recordset object?
>>
>>e.g.
>>oConn = Create('ADODB.Connection')
>>oRecs = Create('ADODB.RecordSet')
>>oConn.Open('MyADOSource')
>>oRecs.Open('select * from MyTable',oConn,3,3)
>>
>>ThisForm.MyGrid.RecordSource = && /now I'm lost?
>>Thanks
>>Pete Kan
>
>Nope. But you can convert from the ADO recordset to a VFP cursor and then back again. There is an article on the VFP web site that explains how to do it.
Craig,
any idea what the article is called ?, I've actually used a method/kludge where I ;
1) Create the ADO recordset
2) Scan through the recordset adding the data to a temporary VFP table
3) Make my changes to the temp table
4) Update the ADO recordset with the temp table.
where do you want to go today????
Regards
Pete Kane
Regards,
Peter J. Kane
Pete