pcsoft.us.windevCopyright 2026, PC SOFT5 Jun 2018 17:31:27 Z1 Jun 2018 19:45:28 ZHello, I have a file with "date" (yyyymmdd) column in Hyperfile. I am not able to via VB6 update the date column, always gives me errors... I've tried several formats. Is there any non-standard specific formatting of OLEDB for this type of column? All other fields I update without any problem. Thanks30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PROGRAMMER / TheProgpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65745/read.awp5 Jun 2018 17:31:27 ZLOL If you knew this definition (adDBDate = 133), you easily knew how it was in Hyperfile! look at this: https://docs.micr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65745/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65745/read.awpOLEDB & HYPERFILE DB Column Date problemfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65739/read.awp5 Jun 2018 15:12:43 ZHi, I was talking about the type on the Hyperfile side and that ...DataType = adDBDate = 133... is not it And now you ar…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65739/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65739/read.awpOLEDB & HYPERFILE DB Column Date problemPROGRAMMER / TheProgpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65736/read.awp5 Jun 2018 12:26:57 Zhello, DataType = adDBDate = 133 (https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/datatypeenum?view=sql-server-20…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65736/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65736/read.awpOLEDB & HYPERFILE DB Column Date problemfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65712/read.awp3 Jun 2018 23:40:38 ZHi first it depends of the SUBTYPE of the field... If it's date/date, then you should send a simple string with YYYYMMDD …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65712/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65691-oledb-hyperfile-column-date-problem-65712/read.awpOLEDB & HYPERFILE DB Column Date problem