Juan Velasquez
asked on
Keep getting "Ambiguous name in query expresion" error
Hello,
I keep getting the error "Ambiguous name in query expresion. 'Swap([Diamond]'. When I try to execute the following query. It's telling me that there is a mispelling or something of that nature. What am I missing?
UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap([Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));
I keep getting the error "Ambiguous name in query expresion. 'Swap([Diamond]'. When I try to execute the following query. It's telling me that there is a mispelling or something of that nature. What am I missing?
UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap([Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for chtullu135's comment http:/Q_27420757.html#37047839
for the following reason:
I found the problem on my own. I discovered that there were two functions with the identical name. When I removed one of them, the query works
Accepted answer: 0 points for chtullu135's comment http:/Q_27420757.html#37047839
for the following reason:
I found the problem on my own. I discovered that there were two functions with the identical name. When I removed one of them, the query works
>>>> two functions with the same name
isn't that what was originally suggested?
isn't that what was originally suggested?
sdstuber suggested exactly that in their first comment: "Do you have multiple objects named Diamond ID". As such, I've accepted that comment as the solution.
SouthMod
Community Support Moderator
SouthMod
Community Support Moderator
ASKER
I had multiple objects named Swap not diamond id but I get your point.
ASKER
I've accepted sdtubers suggestion
ASKER