Version 7.0.0.60 issue

Simple update statement on a single table, no joins, etc.

SQL Prompt underlines and refuses to validate columns "Comment", "InventoryID" and "StatusID".
It states, "The column X could not be resolved as a column with that name exists in multiple tables."
Those column names do exist in other tables in the database. First I've seen this error. I just updated from 7.0.0.40 to 7.0.0.60 today.

RHA8z22.png?1

    UPDATE  &#91;InventoryHeader&#93;
    SET     &#91;StatusID&#93; = 3,
            &#91;PostedBy&#93; = @PDSID,
            &#91;PostedDate&#93; = CURRENT_TIMESTAMP,
            &#91;Comment&#93; = ISNULL(@Comment, &#91;Comment&#93;)
    FROM    &#91;InventoryHeader&#93;
    WHERE   &#91;StatusID&#93; = 2
            AND &#91;InventoryID&#93; = @InventoryID;

jsreynolds1 September 21, 2015 19:35

Comments

5 comments

Hi John,

Apologies, it looks like this was a knock on from a bug fix we added in 7.0.0.49 to qualify column names if they're ambiguous in an UPDATE statement. However it looks like the logic wasn't correct if the UPDATE statement was updating from the same table as its target.

We think we've got a fix in the latest build which you can download from here.

Thanks for reporting this!

Aaron.

Aaron L September 22, 2015 06:34

0
Aaron,

I can confirm that the new build fixes the issue.

Best,

John

jsreynolds1 September 22, 2015 12:58

0
Hi John,

Thanks for the confirmation! I'm glad that fixed it. Please do let us know if you have any other issues.

Thanks,
Aaron.

Aaron L September 23, 2015 05:08

0
Hello!

I have run into a similar problem (and I am on version 7.0.0.62) where the SQL Prompt complains: "... column could not be resolved as a column with that name exists in multiple tables...". Below is my query (slightly revised to protect the innocent):

UPDATE TableA
SET Column1 = ( SELECT Column1
FROM TableB
)
WHERE Column1 IS NULL
AND MyType = 'A';

mishaluba December 30, 2016 12:37

0
Upgrading to the latest version (7.3.0.775) solved this problem for me.

mishaluba December 30, 2016 14:45

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Version 7.0.0.60 issue

Comments

Add comment