1. Forum
  2. USENET
  3. comp.lang.clarion

  • address Table:Field by string

    From Joep Borghans@joep.borghans@gmail.com to comp.lang.clarion on Wed Jun 10 07:59:36 2020
    From Newsgroup: comp.lang.clarion

    Hi All

    I want to get a grip on a field that I know by string.
    This is the code:


    Clear(Xml003)
    Xml003{Prop:Sql} = 'Select recid,xmlTag,Table,Field from xml003'
    Loop
    Next(Xml003)
    If Errorcode() Then Break.

    In Table I have the string 'SAD120'
    In Field I have the string 'RefNr'

    lFieldString = Xml003:Table & ':' & Xml003:Field

    What I want to do is give refnr from Sad120 a new value
    Normally that would be SAD120:RefNr = '23ABC'

    But I only have the string 'Sad120:Refnr'.
    How can I get grip on the field with this string?
    Something like referenceveld &= GetFieldByString(lVeldString)

    End

    Regards,
    Joep
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Sean H@sean@none.com to comp.lang.clarion on Sun Jun 14 11:21:57 2020
    From Newsgroup: comp.lang.clarion

    On 11/6/20 12:59 am, Joep Borghans wrote:
    Hi All

    I want to get a grip on a field that I know by string.
    This is the code:


    Clear(Xml003)
    Xml003{Prop:Sql} = 'Select recid,xmlTag,Table,Field from xml003'
    Loop
    Next(Xml003)
    If Errorcode() Then Break.

    In Table I have the string 'SAD120'
    In Field I have the string 'RefNr'

    lFieldString = Xml003:Table & ':' & Xml003:Field

    What I want to do is give refnr from Sad120 a new value
    Normally that would be SAD120:RefNr = '23ABC'

    But I only have the string 'Sad120:Refnr'.
    How can I get grip on the field with this string?
    Something like referenceveld &= GetFieldByString(lVeldString)

    End

    Regards,
    Joep


    lookup WHO, WHAT, in the help

    You might also try asking on the groups at new.softvelocity.com and also
    try www.clarionhub.com



    Sean H

    --- Synchronet 3.21d-Linux NewsLink 1.2