>>>I didn't mean to detract from the cool factor. Anything that makes manipulation of data easier, with less code, is by definition cool. <g> I've been playing with ADO for awhile as it relates to web pages and in many ways, we definitly have more cool commands within FoxPro and I hope Microsoft continues to surprise us with new ones. A native FoxPro recordset object should definitly be on that wish list, on the other hand, maybe it would be possible to create one with what we have? Hmmm... Guess I have something to play with tonight.
>>>
>>>Mike
>>
>>Hello Mike,
>>
>>Any luck with this so far? What about just using, say, COPY TO ARRAY command (and the array may be the some object property)?
>>
>>Nick
>
>Didn't get to it yet. I teach an ASP class Monday and Wednesday nights and sometimes get just too tied up. Hopefully tonight. But you are on the right track (or at least the track I was going to pursue. Pass the SQL statement to an object, execute the statement in the object to save the data to an array. Provide methods to access a record (row), like MoveFirst, MoveLast, MoveNext, MovePrevious, etc. Events to DELETE, ADDNEW, etc. just like ADO, but using an object that contains the data as an array.
>
>Mike
But is it really necessary? You can pass the object with the array somewhere and then convert the array to the cursor again, and use the native FoxPro commands for processing, right?
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison