Can Not Change Date ?

[peterlaursen]

Please

 

1) tell what exactly you do when you save? You will have to either click the save button (the small diskette icon) or move the cursor vertically to another row. Save does not happen when you move the cursor horizontally (to another column/cell in same row)

2) check in HISTORY tab what UPDATE statement SQLyog sends to the server. 

3) check in MESSAGES tab of SQLyog for errors or warnings. 

[peterlaursen]

Here SQLyog sends the statement 

 

UPDATE `sritex3`.`faktur1_copy` SET `TGBUKTI` = ‘2015-02-05’ WHERE `KD_CUST` = ‘J.KAG.001’ AND `NO_FAKTUR` = ‘FLJ/GARMT/10087/0115’ AND `NO_MP` = ” AND `TGL_FAKTUR` = ‘2015-01-06’ AND `JUMLAH` = ‘4875305985.00’ AND `KETBRG` = ‘PJAB0072/21   GM01’ AND `KD_BARANG` = ‘424510000501’ AND `ITEMG` = ”; 

(you have a very complex primary key and that causes the many WHERE conditions)

 

..and it works as expected (I tried on MySQL 5.5.41). You may try to execute that statement manually (from any client). If it does not change on the server it is a server bug.  Your server (5.1.33) is rather old now. Refer this FAQ: http://faq.webyog.com/content/1/178/en/sqlyog-is-a-client-for-the-mysql-server-_-but-what-server-versions-are-supported.html.  There were a lot of bugs introduced in MySQL between 5.1.30 and 5.1.35 (but they mostly afffected InnoDB, and you are using MyISAM)

[sky_proj]

hi Peter Laursen,

 

i have try this code and worked.. thanks :), here code i have tryed :

UPDATE `sritex3`.`faktur1_copy` SET `TGBUKTI` = ‘2015-02-05’

WHERE `NO_FAKTUR` = ‘FLJ/GARMT/10087/0115’

 

ty

Hendro

[Author]

Posts