How to transform a SQL-Select-Object into a Cursor

[siotti]

I did some tests on SQL-Select on my existing VFP-Database. As expected it's high-grade compatible with VFP . I can store the result in a cursor, table and array.

But there are also some very interesting enhancements on this topic in Lianja. For example it's possible, to create XML and also an object directly from SQL-Select:

select * from table into object oResult

I found, that i can iterate over each row of the result-object using "foreach":

foreach oResult AS row
?row.fieldname
endfor


But is there also an easy way to transform the object into a cursor? Maybe a special function like "Object2Cursor()", or something like this:

select * from object oResult into cursor cResult

Of course, i could write a function to do the transformation, but maybe there is already a possibility to do that?

[HankFay]

I haven't tested it, but from what Barry has written, I think you can do:

oCursor = oResult.cursoradapter()

Hank

[barrymavin]

No there is no function for that.