12 lines
344 B
Plaintext
12 lines
344 B
Plaintext
CLOSE DATABASES ALL
|
|
SET SAFETY OFF
|
|
MODIFY FILE file1.csv NOEDIT
|
|
*!* Create a cursor with integer columns
|
|
CREATE CURSOR tmp1 (C1 I, C2 I, C3 I, C4 I, C5 I)
|
|
APPEND FROM file1.csv TYPE CSV
|
|
SELECT C1, C2, C3, C4, C5, C1+C2+C3+C4+C5 As sum ;
|
|
FROM tmp1 INTO CURSOR tmp2
|
|
COPY TO file2.csv TYPE CSV
|
|
MODIFY FILE file2.csv NOEDIT IN SCREEN
|
|
SET SAFETY ON
|