On Thu, 9 Jan 2003 [EMAIL PROTECTED] wrote: > trainee ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > varchar 's comparision > > Long Description > SERVER: PGSQL 7.31 + MANDRAKE LINUX 8.1 > CLIENT: VISIVAL FOXPRO 7.0 + PGSQLODBC 7.02 > > TABLE : MYTABLE > M_ID VARCHAR(10) M_DESC VARCHAR(10) > ----------------------------------------------------------- > ABC HELLO > > I create a romate view in vfp, when I modify "m_desc" from "HELLO" > TO "GOOD" ,and update table, vfp trigger a error "UPDATE CONFLICT". > > In odbc-log: (THIS SQL SYNTAX IS GENERATED BY VFP ) > --------------------------------------------------------------- > UPDATE MYTABLE SET M_DESC='GOOD' WHERE M_ID='ABC ' AND M_DESC='HELLO '
varchar() considers trailing spaces as significant, so 'ABC'!='ABC ' If it's going to generate values with trailing spaces, you might want to use char() instead. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org