Re: MySQL Question

new topic     » goto parent     » topic index » view thread      » older message » newer message
  • Posted by m_sabal Nov 29, 2012
  • 1077 views

My first suggestion is to upgrade MySQL to at least version 5.0 (version 5.6 is available), and to use the command line MySQL client for testing to rule out any other possible problems (such as a precision bug in your program, the version of the ODBC library, or the MySQLConnector ODBC driver). Could you run the query "SHOW COLUMNS IN stars" and post the results?

Also, replace is not a standard SQL query. The correct query should be like this:

sql = "update stars set RAnumeric = 2.60106457, DECnumeric = 6.88336423 where recordkey="&recordkey

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu