1. Forum
  2. Usenet
  3. COMP.LANG.CLARION

  • address Table:Field by string

    From Joep Borghans@21:1/5 to All on Wed Jun 10 07:59:36 2020
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sean H@21:1/5 to Joep Borghans on Sun Jun 14 11:21:57 2020
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)