pcsoft.us.windevCopyright 2026, PC SOFT30 Aug 2018 21:14:12 Z28 Aug 2018 15:19:49 ZIs there a way to get SQLCol() to not remove trailing zeroes from a result field? I have a query against an SQL database connected via SQLConnect(sServer, sUser, sPassword, sDatabase, "OLEDB", hOledbSQLServer) with one column specifically formatted with 5 decimal places. But SQLCol() is getting rid of all of the zeroes at the end, so when the result is for example 27.25000 it's cutting it off as 27.25.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)robpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66810/read.awp30 Aug 2018 21:14:12 ZThanks for the tips!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66810/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66810/read.awp[WD22} SQLCol() removing trailing zerosmeiklpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66784/read.awp29 Aug 2018 09:30:30 Zmy guess as it is returned as a native number you have to adjust the imputmask-property for visualizing meikl ;)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66784/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66784/read.awp[WD22} SQLCol() removing trailing zerosfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66780/read.awp28 Aug 2018 23:55:57 ZHi Robert, it looks like your column is of numerical type... if that is correct, then the 5 decimal thingy is ONLY at the D…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66780/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66775-wd22-sqlcol-removing-trailing-zeros-66780/read.awp[WD22} SQLCol() removing trailing zeros