XSharpPublic icon indicating copy to clipboard operation
XSharpPublic copied to clipboard

[VFP] Cursor operation - SQL SELECT INTO Cursor

Open MarioV-GH opened this issue 1 year ago • 0 comments

Describe the bug xSharp Error when using SELECT into Cursor

To Reproduce

        create cursor abc (mkey i, mident c(10))
        insert into abc (mkey,mident) values (1,"a")
        insert into abc (mkey,mident) values (2,"b")
        insert into abc (mkey,mident) values (3,"c")

        create cursor def (mkey_fk i,mtext c(10))
        insert into def (mkey_fk,mtext) values  (1,"inf1")
        insert into def  (mkey_fk,mtext)  values (1,"inf2")
        insert into def  (mkey_fk,mtext)  values (2,"infA")

        insert into def  (mkey_fk,mtext)  values (3,"to_del")
        insert into def  (mkey_fk,mtext)  values (4,"to_del")

        LOCAL cCur_Target AS STRING
        cCur_Target = "jkl"
        SELECT abc.* FROM abc INTO cursor mno
        SELECT abc.* FROM abc INTO cursor (cCur_Target)

Expected behavior Full support of Native VFP SQL-Select

MarioV-GH avatar Oct 02 '24 10:10 MarioV-GH