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

[MVWKFS]

Hi Robert,
thanks for your quick feedback. I wonder if it would be meaningful to create issues for those examples at the github-site?
https://github.com/X-Sharp/XSharpPublic
It would be important to have a better coverage of these SQL/Cursor Operations to move on with xSharp.
Looking forward to the Summit in October,
Br Mario

[robert]

Mario,
It is always good to create issues for things that you are missing.
It helps to remind us of these things, and you will be notified of our work on the issues.
Please try to put 1 item per issue, so it is easier to close issues and follow the progress.

Robert