Post reply

TableDiff.exe - Unable to create UPDATE message

  • June 16, 2009 at 7:08 am

    #206557

    Hello,

    I have written a script to compare and script table differences by calling the tablediff.exe.

    I noticed that some tables return the following error:-

    The differences I have found, occur when checking columns with a REAL data type.

    The values in each table are different, but most of the precision is correct.

    Is there anyway of getting around this issue?

    Thanks for any help

    Paul

  • June 16, 2009 at 7:09 am

    #1010149

    The error message did not appear in the previous post, it is -

    unable to create UPDATE for record with only large data types

  • June 18, 2009 at 9:50 am

    #1011877

    Anyone have any thought on this? 😀

  • January 4, 2010 at 11:59 am

    #1098557

    I'm experiencing the same issues as well. My tables do not contain any large data types either. The table has only two rows and both are of type INT:

    unable to create UPDATE for record with only large data types

    Anyone have any thoughts?

    snewman

  • April 29, 2021 at 9:52 pm

    #3877569

    I realize this is an ancient post, but for anyone stumbling in here, my issue was that it could not create the sql because the only diff was caps vs lowercase. Cheers.

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

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