Local Cursor Operations with SQL and INDEX

This forum is meant for questions about the Visual FoxPro Language support in X#.

Post Reply
MVWKFS
Posts: 1
Joined: Thu Aug 18, 2022 8:38 am
Location: Austria

Local Cursor Operations with SQL and INDEX

Post by 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
Attachments
examples.txt
(2.03 KiB) Downloaded 25 times
User avatar
robert
Posts: 4352
Joined: Fri Aug 21, 2015 10:57 am
Location: Netherlands

Re: Local Cursor Operations with SQL and INDEX

Post by 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
XSharp Development Team
The Netherlands
robert@xsharp.eu
Post Reply