distal-attribute
distal-attribute
distal-attribute
distal-attribute

Error with decimal point

User, date Message
Written by Jirka Privratsky
10 months ago
Category: HeidiSQL portable
1 posts since Tue, 18 Jun 13
I have got problem with decimal point. When I try to edit row in table ( including data type DECIMAL(6,2) ), Heidi generates error message "SQL Error (102): Incorrect syntax near ‘,’."
In table without data type DECIMAL is OK
Server: MS SQL 2008 Express, database collation is Czech_CI_AS.
Client: HeidiSQL Portable 8.0.0.4396, OS Win7 64-bit, WinXP Pro ( Czech localization )

My own application runs properly ( no problem with decimal point ), but I need from time to time edit data in table. Have You got any idea for solving this problem ?
have nice day
Jirka
Written by kalvaro
10 months ago
563 posts since Thu, 29 Nov 07
I cannot reproduce it with latest snapshot (8.0.0.4427). The grid editor only accepts the decimal separator set in my regional settings (comma) and HeidiSQL generates correct SQL:

"... SET DECIMAL_TEST"=1.78



(There's no way though to edit DATETIME or IMAGE columns.)
Written by Program4fun
10 months ago
3 posts since Tue, 25 Jun 13
I have nearly the same problem in Version 8.0.0.4429. Some days ago I updated HeidiSQL to version 8. I'm not sure, but in the earlier version that worked fine.

If I execute a query and some recordsets are displayed I can not copy&paste a floating point value.
If I change a value manually (by F2) I get this:

UPDATE `Anlagen` SET `Nennleistung`=8.45 WHERE `ID`=5277;
/* No error */

But with STRG+C and STRG-V I get this:

UPDATE `Anlagen` SET `Nennleistung`=8,45 WHERE `ID`=5288; #
/* SQL Fehler (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '45 WHERE `ID`=5288' at line 1 */

Server: MySQL 5.1.69, database collation is utf8_general_ci
Client: HeidiSQL 8.0.0.4429, Win7 64Bit (german)


Gruß
Program4fun
 

Please login to leave a reply, or register at first.