pcsoft.us.windevCopyright 2026, PC SOFT8 Jun 2020 10:51:59 Z3 Jun 2020 06:28:05 ZHi I am using Windev 25 with a MSSQL data base with the following code. dsConsds is Data Source sConstring is string bConsbyte is boolean sConstring = "select recordidentfier,conno,date_date,receivingtown,postcode,reczone,carrierservice,seczone,sendzone,sellcharge,buycharge,carriercharge,totweight,sellchargeweight,buychargeweight,cubic,Receiver,errortype,sendzone,validated from cons where clientid = %1 and carrier = '%2' and carrieraccount = '%3' and validated = %4" sConstring= StringBuild(sConstring,TABLE_custlist.COL_Clientis,TABLE_Carrierslist.COL_Carrier,TABLE_Carrierslist.COL_Account,bValidated) TableDeleteAll(TABLE_conslist) bConsbyte = HExecuteSQLQuery(dsConsds,sConstring) IF bConsbyte = True THEN FOR EACH dsConsds TableAddLine(TABLE_conslist,dsConsds.recordidentfier,dsConsds.conno,dsConsds.errortype,dsConsds.date_date,dsConsds.receivingtown,dsConsds.postcode,dsConsds.carrierservice,dsConsds.sendzone,dsConsds.reczone,dsConsds.seczone,dsConsds.sellcharge,dsConsds.buycharge,dsConsds.carriercharge,dsConsds.totweight,dsConsds.sellchargeweight,dsConsds.cubic,dsConsds.receiver,dsConsds.validated ) END END HourGlass(False) I retrieves the data and adds it to a memory table all the returned data is correct except for the date, it seems that the data source does not allow a big enough field dsConsds _SOURCE_dsConsds_3 recordidentfier 285 conno PDU100000004 date_date 2020-03- receivingtown WINNELLIE postcode 0820 reczone DWN carrierservice EXPRESS seczone sendzone ADL sellcharge 29.02 buycharge 29.02 carriercharge 0 totweight 40 sellchargeweight 0 buychargeweight 0 cubic 0.16 Receiver ENZED DARWIN WINNELLIE errortype NO SELL OR BUY TNTEXP P S Sendzone2 ADL validated 0 This is the data received the date_date is truncated, it is cutting off the day does anyone have any suggestions30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PeHoBepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source-67866/read.awp8 Jun 2020 10:51:59 ZHi Kel, If it is defined as a date type column is SQL server it should come in as a date in WX. Maybe it concerns a UTC datet…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source-67866/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source-67866/read.awpData sourcemarkus.strausspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source-67864/read.awp4 Jun 2020 15:42:47 ZWell obviously you receive the date from SQL Server in a format like yyyy-mm-dd (in a string), whereas the Date variable is init…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source-67864/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67859-data-source-67864/read.awpData source