You can copy current record to a temp file, change it there and append back to the table
lcTempFIle = " ... "
SELECT mytable
COPY NEXT 1 TO (lcTempFIle )
...
SELECT mytable
APPEND FROM (lcTempFIle )
ERASE (lcTempFIle )
You can aslo do the same using SELECT ... INTO CURSOR READWRITE.
>in an application i have a general field which is used to hold a barcode image for printing. This is generated by an ocx (tbarcode4).
>
>i find that i need to create a copy of the record in order to do some manipulation of the fields. however the scatter/gather as i am sure you all know does not copy general fields. Is there any way to copy the contents of the original records General field without having to re barcode the record ?
>
>TIA
>
>Colin Burton
--sb--