pcsoft.us.windevCopyright 2026, PC SOFT8 Jan 2015 10:59:00 Z7 Jan 2015 23:18:00 ZHi, I have some odd behavior. When I save a record form a table then it gets saved with 4 digets instead of 2 as it should have . In the table the number has two digets ( currency format , table has mask defined by project) Ok, when saving the table a lot happens the rows are saved in several tables. Sometimes some calculations are done as well. For instance if costs are added , specific leger functions specify if vat is to be calculated. Several vat percentages can apply. If Vat does apply a row is added with the calculated amout. For variables in the code I use the currencytype Should I use integer or real- for variables- instead of the currency type? It is verry irritating for now my checks ( to see if debet is equal to credit ) fire a fault because for instance 72,52 is not equal to 72,5189 In the analysis I stated that currency has two digits. In the code I made the variables of the currency type. My program is an accounting system. It has complete integration of ledger and accoutreceiveble etc. so this is a real showstopper. Has any of you had this odd behavior or know a solution? Regards Allard30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49794/read.awp8 Jan 2015 10:59:00 ZHi, Thanks Indeed a stupit question. when I read this posting I found out myself that it had to do with the vat calculation. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49794/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49794/read.awp4 decimals instead of two in the hyperfile db ( wd 18 )infopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49788/read.awp8 Jan 2015 09:55:00 ZHi Allard, I am also in the business of creating general ledger (accounting) software. There is a difference with the nati…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49788/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49788/read.awp4 decimals instead of two in the hyperfile db ( wd 18 )guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49793/read.awp8 Jan 2015 09:42:00 ZHi Allard To complete Steven message... You should NEVER use REALs... REAL have a built in flaw that makes them completely…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49793/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49793/read.awp4 decimals instead of two in the hyperfile db ( wd 18 )guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49792/read.awp8 Jan 2015 09:37:00 ZHi Allard, what you are seeing is absolutely NORMAL. The Currency type has ALWAYS a 6 decimal part - just to avoid (common) ro…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49792/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49783-4-decimals-instead-two-hyperfile-49792/read.awp4 decimals instead of two in the hyperfile db ( wd 18 )