Re: MySQL Question
- Posted by gwalters Nov 28, 2012
- 1169 views
Can you please give us a little more detail about the data in the table before you add the mentioned value and the server environment, including the version of MySQL. Also, are you using the mysql cli client or a GUI of some kind?
I discovered that I was getting stars placed in the wrong place. I am updating what was in the my star database with coordinates RA and DEC that were from the Hipparcos database which had a lot of accuracy. The sql statement looks like this and both table entries are double precision;
sql = replace stars values RAnumeric, DECnumeric with values (2.60106457, 6.88336423)
than here is the code snipit
a = execDirectODBC(dbId, sql) if atom(a) then odbcError(-a) a = message_box("Can't find record " & openTbNames[t] & " " & recordKey&" to update.","",0) abort(1) else -- OK end if
After this update I checked the table entry for the double var using mysql query and get the wrong value mentioned above. I am using MySql 4.00.22 and matt's odbc.e routines.It looks like what is in the database is single precision. Any suggestions?
