ODBC .net sql update error 10713

[paledecay]

I'm trying to do a very simple update statement from some VisualStudio2008 C# .net (3.5) code and I'm receiving the following error message:

ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "."mfg-tagm"."location" = 'T' WHERE pub."" (10713)

Progress Database version is 10.2B03. Connecting through a system DSN using the Progress 10.2B driver.

The sql statement in code looks like:
sql = "UPDATE pub.\"mfg-tagm\" SET pub.\"mfg-tagm\".\"location\" = '" + loc + "' WHERE pub.\"mfg-tagm\".\"tag-nbr\" = '" + tag_nbr + "'";

and the sql statement processed looks like:
UPDATE pub."mfg-tagm" SET pub."mfg-tagm"."location" = 'T' WHERE pub."mfg-tagm"."tag-nbr" = '123456'

My select statements, using the same format, work perfectly fine. I've tried using []'s instead of double quotes, but have found that progress does not like []'s..

Any form of insight on this error would be great. I've browsed through the progress.com knowledge base and haven't really found anything helpful with this issue.

Thanks.

 

[medu]

UPDATE pub."mfg-tagm" SET pub."mfg-tagm"."location" = 'T' WHERE pub."mfg-tagm"."tag-nbr" = '123456'

you should drop using the full qualified name for the SET column(s)...

UPDATE pub."mfg-tagm" SET "location" = 'T' WHERE pub."mfg-tagm"."tag-nbr" = '123456'

 

[paledecay]

Ha.
About the only thing I didn't try.

Thank you. Worked perfectly.