Re: [SQL] Question about update syntaxt

2005-04-29 Thread Stephan Szabo
On Fri, 29 Apr 2005, Michael M Friedel wrote: > I am trying to use an application (Through ODBC) that uses the > following update syntax > > UPDATE MyTable SET MyTable.id=2 WHERE id=1 > > unfortunatly I get an error message > > ERROR: column "mytable" of relation "mytable" does not exist > > Ques

[SQL] Question about update syntaxt

2005-04-29 Thread Michael M Friedel
I am trying to use an application (Through ODBC) that uses the following update syntax UPDATE MyTable SET MyTable.id=2 WHERE id=1 unfortunatly I get an error message ERROR: column "mytable" of relation "mytable" does not exist Question is, is ther something I can configure that will make Post