XSharpPublic icon indicating copy to clipboard operation
XSharpPublic copied to clipboard

[VFP] Cursor operation - SQL SELECT with join INTO Cursor

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

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

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