UPDATE-RECORD

Hi,
it is possible in someway:

a. copy one field to another field within the same record
or
b. update ie 2nd multi-value field with specific string

using commang UPDATE-RECORD (or some else)?

I tried (problem a.)

SELECT F.APPLICATION

X records selected

>UPDATE-RECORD F.APPLICATION FIELD.1,EVAL 'FIELD.2'

:) and so on.. doesn't work

PS. jbase 4.1.5.26

thnx in advice

You can build an OFS String
try something like:

SSELECT FBNK.APPLICATION WITH SOME.CRITERIA SAVING EVAL "'APP.NAME,,USER/PWD,':@ID:',FIELD.COPIED::=':FIELD.TO.COPY.FROM"

then

SAVE.LIST TEST.TXT

then

tSS OFS.SOURCE.ID
Paste the content of file TEST.TXT


Provide the Aplication and i can build the OFS string for you

Study OFS, you can also update records and multivalue fields.


Regards