List:MySQL ODBC« Previous MessageNext Message »
From:Michael Widenius Date:June 29 1999 6:29pm
Subject:Re: ODBC: "Write conflict" from access.
View as plain text  
>>>>> "Steve" == Steve Webb <swebb@stripped> writes:

Steve> Another good guess, but I have a "DATETIME" and a "TIMESTAMP" field.  No
Steve> "DATE" fields.  I sense, from the proposed solutions so-far, that there is no
Steve> ODBC problem and just a date issue.  Could it be that the clocks on the server
Steve> and the client machine are just "enough" off to cause a problem? 

I don't think so.

Could you try to execute the query in the mysql client and try to find 
out why it doesn't find any matching rows.

Steve> | | query: Query = "UPDATE Fixed_Assets SET login='test'  WHERE ID = 9 AND
Steve> login = 'crook' AND system_name = 'alpha' AND type = 'cpu' AND description =
Steve> 'PB46A-AA' AND location = 'FL2-2080' AND serial_number = 'KA513VUKN9' AND
Steve> nsf_number IS NULL AND ppe_number = 'PPE000000701' AND po_number = '52391' AND
Steve> vendor = 'DEC' AND date_installed = 19950413000000 AND status IS NULL AND
Steve> timestamp = 19961112000000 AND project = '170113' AND architecture = 'DEC' AND
Steve> operating_system IS NULL"

Regards,
Monty
Thread
ODBC: "Write conflict" from access.Steve Webb26 Jun
  • ODBC: "Write conflict" from access.Michael Widenius29 Jun
    • Re: ODBC: "Write conflict" from access.Steve Webb29 Jun
      • Re: ODBC: "Write conflict" from access.Michael Widenius29 Jun
        • Re: ODBC: "Write conflict" from access.Steve Webb29 Jun
          • Re: ODBC: "Write conflict" from access.Steve Webb29 Jun
            • Re: ODBC: "Write conflict" from access.Steve Webb29 Jun
              • Re: ODBC: "Write conflict" from access. (FIXED IT!)Steve Webb29 Jun