This section is for all the FoxPro programmers out there. Included with the ITRDS is a utility class that will help you re-create cursors from the query results (or "LoadTable" method) of the ITRDS. To use this class simply include it in your Library. Then you can use it as follows

loITRDS.OWORKORDERS.query("select * where account = ' 2744262'","",1)

lcQueryXML = loITRDS.OWORKORDERS.cResultXML

loDataConvert = Createobject("IT_Dataconvert")

loDataconvert.xmlwithschematocursor(lcXML,"table")

The above method will create a FoxPro cursor from the XML. If you want to include indexes from the source table then use the LoadTable method as follows

loITRDS.OWORKORDERS.LoadTable("account = ' 2744262'",,,1)

lcQueryXML = loITRDS.OWORKORDERS.cResultXML

loDataConvert = Createobject("IT_Dataconvert")

lGetIndexes = .t.
lSuccess = loDataconvert.xmlwithschematocursor(lcXML,"table",,lGetIndexes)

This will create a cursor along with all the indexes that are on the source table back in Rams