rs! question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Cyberwolf

    rs! question

    Why can't I write to a field name 2ndItemNumber with

    rs!2ndItemNumbe r = st2nd. When I type that in I get a message expected end
    of statement and "ndItemNumb er" is highlighted. I know it has something to
    do with the 2 but I can't figure out how to get around it.

  • ARC

    #2
    Re: rs! question

    Yeah, you can't start a field with a number sign and reference it without
    special treatment.

    A fix would be to bracket the field, as in: rs![2ndItemNumber] = st2nd

    Hope this helps,

    "Cyberwolf" <u41738@uwewrot e in message news:8076ec22b8 059@uwe...
    Why can't I write to a field name 2ndItemNumber with
    >
    rs!2ndItemNumbe r = st2nd. When I type that in I get a message expected
    end
    of statement and "ndItemNumb er" is highlighted. I know it has something
    to
    do with the 2 but I can't figure out how to get around it.
    >

    Comment

    • Arch

      #3
      Re: rs! question

      On Fri, 29 Feb 2008 12:37:55 -0600, "ARC" <PCESoft@PCESof t.invalid>
      wrote:
      >Yeah, you can't start a field with a number sign and reference it without
      >special treatment.
      >
      >A fix would be to bracket the field, as in: rs![2ndItemNumber] = st2nd
      >
      >Hope this helps,
      >
      >"Cyberwolf" <u41738@uwewrot e in message news:8076ec22b8 059@uwe...
      >Why can't I write to a field name 2ndItemNumber with
      >>
      >rs!2ndItemNumb er = st2nd. When I type that in I get a message expected
      >end
      >of statement and "ndItemNumb er" is highlighted. I know it has something
      >to
      >do with the 2 but I can't figure out how to get around it.
      >>
      Or,

      rs("2ndItemNumb er") = st2nd

      Comment

      Working...