pcsoft.us.windevCopyright 2026, PC SOFT25 Jan 2015 20:28:00 Z22 Jan 2015 13:29:00 ZHey I'M GOING CRAZY !!!:hot: When i use HADD(FILENAME) all of a sudden i get the error: Error 80040e21 returned by SQL Server Description: Invalid character value for cast specification SQL State: 22018 SQL Error Number: 0 But when i use the same values in a insert query there are no errors Can some help me please TIA Jan de Bruin30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50085/read.awp25 Jan 2015 20:28:00 ZFabrice Your explanation was correct and i did understand it. :spos: TIA Janhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50085/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50085/read.awpNATIVE MSSQL + WD19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50084/read.awp25 Jan 2015 20:10:00 ZHi Jan I am not sure how to better explain it than what I said in my previous post: When you are doing an insert query, th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50084/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50084/read.awpNATIVE MSSQL + WD19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50079/read.awp25 Jan 2015 11:01:00 ZHey fabrice, Thanks for your reply. Things getting confuser for me... Some values i can add without any problem. The valu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50079/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50079/read.awpNATIVE MSSQL + WD19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50003/read.awp22 Jan 2015 13:46:00 ZHi Jan it looks like your analysis is not correct compared to the SQL DB, at the level of the type of at least one field W…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50003/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50002-native-mssql-wd19-50003/read.awpNATIVE MSSQL + WD19