XSharpPublic
XSharpPublic copied to clipboard
[VFP] Cursor operation - SQL SELECT with join INTO Cursor
Describe the bug xSharp error when using SQL Select with join
To Reproduce Code to reproduce the behavior:
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")
SELECT * FROM abc JOIN def ON abc.mkey=def.mkey_fk INTO cursor ghi
Expected behavior Full Support of SQL SELECT incl JOIN