XSharpPublic
XSharpPublic copied to clipboard
[VFP] Cursor operation - SQL SELECT INTO Cursor
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