Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Invalid Argument

Discussion in 'Information Technology' started by Sharkbyte, Jul 28, 2006.

  1. Sharkbyte

    Sharkbyte
    Expand Collapse
    Guest

    I have a db that has begun to display an Invalid Argument error, when
    attempting to run an UPDATE statement. I have looked at the data, thinking
    it may be an issue with a reserved character. However, when testing other
    data, that have the same characters, the problem does not occur.

    Could this be record corruption, or does someone see a data issue, that I am
    missing?

    The data is:

    Standard Wireless Communications Kits (includes: 1 indoor with 15 inch
    antenna and 1 outdoor wireless modems with 20 foot antenna)

    the SQL is:

    DoCmd.RunSQL ("Update tblinventory set itemdesc = txtitemdescription where
    itemid = txtitemid;")

    Thanks, in advance.

    Sharkbyte
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikh rendered invalid in ’84 riots seeks justice (Gulf Times) Breaking News Mar 14, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (Calcutta News) Breaking News Mar 13, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (New Kerala) Breaking News Mar 13, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (Hindustan Times) Breaking News Mar 13, 2008
    1984 1984 anti-Sikh riots: Sajjan Kumar, others conclude final arguments History of Sikhism Feb 5, 2013

  3. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    Assuming that txtitemdescription and txtitemid are either controls on the
    form in whose module the code is running, or are variables in the module you
    should concatenate their values into the string expression. Text data should
    be delimited with quotes, so if the description is a text data type and the
    itemid a number data type the code would be:

    DoCmd.RunSQL ("UPDATE tblinventory set itemdesc = """ & txtitemdescription
    & """ WHERE itemid = " & txtitemid)

    Ken Sheridan
    Stafford, England

    "Sharkbyte" wrote:

    > I have a db that has begun to display an Invalid Argument error, when
    > attempting to run an UPDATE statement. I have looked at the data, thinking
    > it may be an issue with a reserved character. However, when testing other
    > data, that have the same characters, the problem does not occur.
    >
    > Could this be record corruption, or does someone see a data issue, that I am
    > missing?
    >
    > The data is:
    >
    > Standard Wireless Communications Kits (includes: 1 indoor with 15 inch
    > antenna and 1 outdoor wireless modems with 20 foot antenna)
    >
    > the SQL is:
    >
    > DoCmd.RunSQL ("Update tblinventory set itemdesc = txtitemdescription where
    > itemid = txtitemid;")
    >
    > Thanks, in advance.
    >
    > Sharkbyte
     

Share This Page