同一字段两行记录相减,如何实现?
CREATE CURSOR T (A N(2),B N(2))FOR I=1 TO 10
INSERT INTO T (A) VALUES (I)
ENDFOR
SELECT A,RECNO()+1 JLH FROM T WHERE RECNO()<RECCOUNT() INTO CURSOR TT
SCAN
UPDATE T SET B=A-TT.A WHERE RECNO([T])=TT.JLH
ENDSCAN
SELECT T
BROWSE
表记录超15万,这样处理太慢了,添加到数组下标也超限了,在线求解?