All,

I'm seeing issues with COPY TO ARRAY. The following illustrates it on my machine today:

create cursor ffff (g_ggx c(1))
insert into ffff values ("A")
insert into ffff values ("B")
insert into ffff values ("C")
insert into ffff values ("D")
insert into ffff values ("E")
declare laTest(50,1)
laTest=""
COPY TO  laTest FIELDS g_ggx
SET STEP ON

Looking at laTest content in Debug, first 5 rows ought to be populated with field content- but nix. HELP refers to Tables as source for COPY TO ARRAY and there's no mention of Cursors, but SCATTER to ARRAY from a cursor works beautifully and I'd expected COPY TO would too.

Issue is that I want that array size to be maintained with blank rows for the surplus. The other option is SELECT into ARRAY, but Tamar's paper calls that an order of magnitude slower for a small resultset and it also truncates the array- which breaks the intended model.

Any advice appreciated! I've experimented with NOOPTIMIZE and FOR .T. as well as large cursors that ought to spool to disk (in case it's the memory-residency that's the cause) but it reproducibly refuses to populate the array from a cursor....