XSharpPublic
XSharpPublic copied to clipboard
VFP Cursor Operations - SELECT INTO ARRAY
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.
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.