List:MySQL ODBC« Previous MessageNext Message »
From:artem Date:July 5 2003 6:54am
Subject:RE: myodbc / delphi / date fields
View as plain text  
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=1

Thread
Re: myodbc / delphi / date fieldsMike Farmer3 Jul
  • Re: myodbc / delphi / date fieldsClaudio Cicognani4 Jul
    • List Request - for Mailing list adminUnknown Sender4 Jul
      • Re: List Request - for Mailing list adminJim Winstead4 Jul
      • Re: List Request - for Mailing list adminDaniel J. Summers5 Jul
        • [OT]Popfile (was RE: List Request - for Mailing list admin)Santiago Burbano5 Jul
    • RE: myodbc / delphi / date fieldsartem5 Jul