Run this indirect way, the record it is buffered:
CREATE CURSOR PIVOT (FF I)
APPEND BLANK
CREATE CURSOR abba (f1 I)
CURSORSETPROP("Buffering",3)
SELECT TOP 1 00 FROM PIVOT ORDER BY 1 INTO ARRAY vv
INSERT INTO ABBA FROM ARRAY vv
? 'INSERT FROM ARRAY',GETFLDSTATE(-1),RECCOUNT()Run this direct way, the record it is updated:
CREATE CURSOR PIVOT (FF I)
APPEND BLANK
CREATE CURSOR abba (f1 I)
CURSORSETPROP("Buffering",3)
INSERT INTO ABBA SELECT TOP 1 200 FROM PIVOT ORDER BY 1
DEBUGOUT 'INSERT SELECT',GETFLDSTATE(-1),RECCOUNT()Bug,
undoc behaviour
doc behaviour ?
Fabio
