pcsoft.us.windevCopyright 2026, PC SOFT13 Feb 2016 21:06:00 Z12 Feb 2016 16:36:00 ZThis is a strange problem... I have in analysis (mysql tables) a table with a timestamp field whose default value is CURRENT_TIMESTAMP (defined on MySql). So in analysis I see it as DateTime field with "NULL authorized" check disabled, as expeced, and empty default value. When I insert a record my HAdd gives an error telling that that field cannot be null. This due to the fact that I never assign a value to that field in my code for triggering Mysql to fill it with default CURRENT_TIMESTAMP. I sniffed the mysql queries and I saw that the query made by the engine to Mysql tries to assign NULL to that field, as If a Hadd has to set ALL table fields. When I worked witb MySql 5.6 if I set the field to NULL (even if null was not allowed) it run fine... With 5.7 it does not accept this trick anymore. The only way I found to keep out the field with CURRENT_TIMESTAMP default value is to delete it from the datafile in analysis... Bad solution because I need to remove it by hand each time I resync the analysis... Is there another way? With a query by hand it's fine, I would like to make run HAdd Thank you.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56415/read.awp13 Feb 2016 21:06:00 ZHey StefanoG, using the native access and you have an item in the analysis that must have the value NULL when you write the r…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56415/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56415/read.awpKeep out a field from HAddguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56408/read.awp13 Feb 2016 14:17:00 ZAny trick is ok for me. Even removing the field from analysis. That solved the problem. My hope was having a standard way to do …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56408/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56408/read.awpKeep out a field from HAddguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56399/read.awp12 Feb 2016 19:49:00 Zfilling the field with one trigger on mysql instead of default value is acceptable for you?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56399/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56399/read.awpKeep out a field from HAddguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56398/read.awp12 Feb 2016 19:23:00 ZSure but it is machine client timestamp not mysql'shttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56398/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56398/read.awpKeep out a field from HAddguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56396/read.awp12 Feb 2016 18:30:00 Zif you fill it with datesys()+timesys() it works?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56396/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56396/read.awpKeep out a field from HAddguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56395/read.awp12 Feb 2016 17:51:00 ZIn analysis the field has null always disallowed. As in Mysql. It's a specific timestamp value, for my use it cannot be null. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56395/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56395/read.awpKeep out a field from HAddguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56394/read.awp12 Feb 2016 17:32:00 ZYes, Hadd set all the table fields. If the only change is the mysql version probably it's one change in the behaviour between…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56394/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56393-keep-out-field-from-hadd-56394/read.awpKeep out a field from HAdd