Local Cursor Operations with SQL and INDEX

[MVWKFS]

Hello,

I tried xSharp for the first time and wonder how (for our application essential) local cursor operations are working or if there are plans to support those.
In VFP these operations were very fast when using indexes e.g. on cursor-fields with rushmore optimization. Please find attached "examples.txt".

Br Mario

[robert]

Mario,
We have started adding several embedded SQL commands for VFP.
What should work:
- CREATE CURSOR
- CREATE TABLE
- INSERT INTO, except INSERT TO ... SELECT ...
- REPLACE

What does not work
- DELETE FROM
- UPDATE
- SELECT


Especially the SELECT statement is quite complicated. Not the SELECT on a single Cursor/Table but joined selects are complicated.
We plan to add these in the future. But there are also many other things that we want to add.
Also, the IndexSeek() function is not implemented yet.

So far there has not been very much feedback in this area, so that is why this got a lower priority.
W.r.t. rushmore optimizations: we do not have this yet.

Robert