date error with MySQL in Delphi

[aaanadie]

Hi,

I'm using Delphi 2005 and MySQL 4.1. I can not modify a date field:

unit Unit1;

interface

uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, DBTables, StdCtrls, Mask, DBCtrls;

type
TForm1 = class(TForm)
Database1: TDatabase;
Table1: TTable;
DBEdit1: TDBEdit;
DataSource1: TDataSource;
Button1: TButton;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;

var
Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
DBEdit1.Field.DataSet.Post;
end;

end.

The program is very very simple. I do not know what is wrong.

Thanks in advance.

 

[towerbase]

How are you accessing MySQL ?

Possible answers are ODBC, dbExpress and so on.

MySQL requires that the date is in the format 'yyyy-mm-dd'.

HTH

Andrew
Hampshire, UK