Post reply

Update table with subquery

  • February 24, 2010 at 12:01 am

    #217252

    Hi friends,

    UPDATE NIR_INPUT SET NIR_INPUT.SAMPLE = (SELECT [NIR_INPUT1].SAMPLE FROM [NIR_INPUT1] WHERE [ INPUT1].SAMPLE_ID = [NIR_INPUT].SAMPLE_ID);

    this query i could not able to resolve this error, please anyone give me correct script.

    Error is-> Invalid memo OLE, hyperlink object in subquery in '[NIR_INPUT1].SAMPLE '

  • March 1, 2010 at 3:36 pm

    #1126757

    There isn't enough information to be able to help you.

    • What does your environment look like? Is it an Access front-end with a SQL back-end? I can't tell.
    • From a quick glance, your SQL looks like it's fine (as far as I can tell). It's possible the problem is with your data. What does your data look like? (Don't need a lot of it; a few sample lines should suffice.)

    The more detail you can give us, the better we can help. (Warning: do NOT confuse "more detail" with "more information" -- don't write so much to the point that it becomes unreadable!)

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • March 2, 2010 at 12:39 am

    #1126864

    It looks like NIR_INPUT.SAMPLE and NIR_INPUT1.SAMPLE have dishomogenous data types

  • March 2, 2010 at 7:20 am

    #1127069

    grovelli-262555 (3/2/2010)

    It looks like NIR_INPUT.SAMPLE and NIR_INPUT1.SAMPLE have dishomogenous data types

    It could be, but without any sample data, we can't say for sure.

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply