Welcome To T24All
Welcome, Guest
Username Password:

UPDATE-RECORD
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: UPDATE-RECORD

UPDATE-RECORD 1 year, 7 months ago #5346

  • dajrokan
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Karma: 1
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

Re: UPDATE-RECORD 6 months, 1 week ago #8535

  • oscarramol
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: -1
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
  • Page:
  • 1
Time to create page: 0.31 seconds