Hello all, I am using Delphi 5 + MyODBC (ADO) I have a TADOQuery connected to the ODBC data source. This is my SQL string : SELECT tnCUSTOMERS.fnADDRESS1, tnCUSTOMERS.fnADDRESS2, tnCUSTOMERS.fnPSC, tnCUSTOMERS.fnCOMPANY, tnCUSTOMERS.fnICO, tnCUSTOMERS.fnDIC, tnINVOICES.fnDATUM_SPLATNOSTI, tnINVOICES.fnFAKTURA_CISLO, tnINVOICES.fnCASTKA, tnINVOICES.fnDPH, tnINVOICES.fnKONSTANTNI, tnINVOICES.fnINTERNI, tnINVOICES.fnPAID, tnINVOICES.fnDATE_PAID FROM tnINVOICES INNER JOIN tnCUSTOMERS ON tnINVOICES.fnCUSTOMER_CODE = tnCUSTOMERS.fnINDEX WHERE tnINVOICES.fnPAID = 0 When I ADOQuery.Open and I DO NOT have any visual controls connected via a DATASOURCE all is okay. When I attach a datasource and a datagrid, I then get an E_FAIL error. In my SQL statement I return the fields that of of datetime (MySQL datatypes). If I remove all reference to these three fields then all is okay. My question is how can I return date or datetime to my Delphi app and display it in a control. Kind regards Phil curtis --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.228 / Virus Database: 109 - Release Date: 17-01-2001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
