SETPosition issue [3.6 SQL]

Hi, After using setposition and modify the field value, it leaves all other field to blank. Any idea? Thansk Chirag

SETPOSITION does not retrieve a record – it only populates the primary key fields with values. You probably need to do a GET or FIND before modifying fields. Extract from C/SIDE help… SETPOSITION Use these functions to set the fields in a primary key on a record to the values specified in the supplied string. The remaining fields are left untouched.

Is there any way to copy the content of all the fields, and set it back to the same record while using the setposition. Thanks Chirag

I’m sorry – I’m not sure that I follow what you are trying to do. Can you provide a little more context?