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
Error with decimal point
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
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.