vfp local cursors

jpmoschi · Post by **jpmoschi** » Mon Aug 10, 2020 9:33 pm

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

FoxProMatt · Post by **FoxProMatt** » Tue Aug 11, 2020 2:18 am

At this time, this works:

Code: Select all

SqlExec("select ...", "myLocalAliasName")

But this does not:

Code: Select all

Select ... Into Cursor myLocalAliasName

Also, most basic XBase command work... Scan/EndScan, Do While, etc work if use USE the DBF to open it.