Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page