XSharpPublic icon indicating copy to clipboard operation
XSharpPublic copied to clipboard

VFP Cursor Operations - SELECT INTO ARRAY

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

Describe the bug Support of embedded SQL needed - also with the "INTO ARRAY" clause

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")

    LOCAL ARRAY aData[1]
    Select * from abc into array aData

Expected behavior Select fills the vfp-(in that case 2 dimensional) array with mixed types. Elements in the declaration do not really matter.

MarioV-GH avatar Dec 16 '24 08:12 MarioV-GH

We will try to add support for simple SELECT statements in one of the next build. Select into an array should then also be fairly easy to implement.

RobertvanderHulst avatar Dec 17 '24 09:12 RobertvanderHulst