xsharp.eu

Dear forum

I continue analyzing Xsharp to migrate from FoxPro and I would like to know the experts opinion regarding local cursors (something similar to in memory tables or temporary tables for private use, in my case, this are created with Sqlexec("select ...", "myLocalAliasName") or with "select ... into cursor myLocalAliasName" or from another local cursor).
VFP supports all kinds of cursors manipulation:
** Using SQL: selects / insert / update / delete with complex clauses (union, group by, top, distinct, where, order by)
** Traditional dbf manipulation with do while, append, replace, delete, etc

My question is: What would be the best Xsharp approach to emulate foxpro's local cursors?


Thanks in advance
Juan

At this time, this works:
But this does not:
Also, most basic XBase command work... Scan/EndScan, Do While, etc work if use USE the DBF to open it.