trainee (trainee12@yeah.net) 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 '
UPDATE 0 RECORDS
----------------------------------------------------------------
no record be updated, so VFP trigger a error "UPDATE CONFLICT"
But if you execute SQL manually
---------------------------------------------------------
UPDATE MYTABLE SET M_DESC='GOOD' WHERE M_ID='ABC' AND M_DESC='HELLO'
UPDATE 1 RECORDS
---------------------------------------------------------
HOW CAN I DO?
THANKS
Sample Code
No file was uploaded with this report