From: Date: July 5 2003 8:54am
Subject: RE: myodbc / delphi / date fields
List-Archive: http://lists.mysql.com/myodbc/7658
Message-Id: <MCBBKMDOBJNDMAOCAAHCMENPCDAA.artem@w510.tm.odessa.ua>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

have no clue , but i have problem with datatime fields on win98,
vb/ado/myodbc

with datetime column NOT NULL and default values "0000-00-00 00:00:00" (even
one value from all records)

the opened recordset have
"Data provider or other service returned E_FAIL status" in RecordCount and
PageCount
and
"Either EOF or BOF is True or current record has been deleted" in Bookmark
and Satus
Populated datagrid show no records,
populated textboxes fails with error of not found binded field

Only swithcing to default NULL values for datetime works



> -----Original Message-----
> From: Claudio Cicognani [mailto:braintech_software@stripped]
> Sent: Friday, July 04, 2003 6:10 PM
> To: myodbc@stripped
> Subject: Re: myodbc / delphi / date fields
>
>
> Hello,
> I've a problem that sound like the others of this thread.
> I'm using Borland C++Builder 5.0 and MyODBC 3.5x used to access a
> MySQL database (3.23 or 4.0) on a Redhat linux 8.0.
> When I try to apply a filter (using the specifical property o at
> runtime with
> code) on a TTable object to a DateTime field, the Builder
> designer (also at
> runtime) return an error message "Operation not applicable".
> If I replace the MyODBC with an older versione 2.51 everithing go
> well, and
> the filter work correctly on the table/field.
>
> Some helps ?
>
> Thanks in advance.
> ---------------------------------------------
> Claudio Cicognani
>
> BRAIN TECH S.a.s.
> Automazione Industriale
> Hardware & Software
> ---------------------------------------------
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=artem@stripped