I don't see how you could use SET CARRY to do this. But INSERT INTO might work for you. Here's a runnable piece of code that demonstrates what I mean (I assume you need to create records).
X.BUTTON1.TOP = 1
X.TEXT1.TOP = 40
X.TEXT2.TOP = 80
X.SETALL( 'VISIBLE', .T. )
X.SHOW
READ EVENTS
DEFINE CLASS CMDBUT AS COMMANDBUTTON
PROCEDURE CLICK
INSERT INTO TEST (PRESENT, PAST) VALUES (SECONDS(), TEST.PRESENT )
THISFORM.REFRESH()
ENDDEFINE
...snip
>Now how can I SET CARRY TO PREVIOUS column for the value in the PRESENT column?i.e,
...snip