1 Replies - 2001 Views - Last Post: 08 February 2010 - 03:46 PM Rate Topic: -----

#1 Tswakza  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 08-February 10

Conversion from string to type double is not valid

Posted 08 February 2010 - 03:09 PM

Hi there,

I am trying to update MS-Access database where one field is boolean and updating a string. I am getting a error message "Conversion from string "Update Claims set appointed=" to type double is not valid". HOW DO i RESOLVE THIS ERROR
Is This A Good Question/Topic? 0
  • +

Replies To: Conversion from string to type double is not valid

#2 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: Conversion from string to type double is not valid

Posted 08 February 2010 - 03:46 PM

Please show the complete UPDATE query with the update value/variable reference. And clarify what you want to do, your description is confusing. You want to update a string field with Boolean? Or are you updating Boolean with a string? The error message indicates attempt to update a numeric field failed (is Boolean datatype field treated as double?). Is the update value coming from control on form?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1