Devart Forums

Delphi 5 SP1
Mysql 5.0.27
MyDac 4.40.0.21

The problem doesn't occur with previous build.

I can select a date field, but i can't update or insert a date field, the error raised is 'Invalid variant operation'.

Way to reproduce the problem :

_CREATE TABLE TestTable (DateField date default NULL);
insert into TestTable values (Now());

in dephi, drop in a form MyQuery,MyConnection, DataSource ,DbGrid and link them.
Query : 'select * from testtable'

launch the application, you can see the record, but if you try to update this record, or add a new row, the error raise.

Another info maybe useful, my regional options

Short Date Format : jj/MM/aaaa (ex today '14/12/2006')

The date in dbrid is displayed with this format : '14/12/2006'.

We can not reproduce the problem. Please perform the following steps:
1) Close IDE
2) Uninstall MyDAC
3) Search for MyAccess.*, DBAccess.*, mydac*.bpl, dac*.bpl etc files at your HDD and delete them
4) Remove from the project directory all files made by compiler and linker
5) Remove from the registry (HKCU\Software\Borland\Delphi\5.0\Known Packages) all the links to MyDAC packages
6) Run IDE and check that it is started without errors
7) Close IDE
Download MyDAC and install it

If this will not help, send me to evgeniyD * crlab * com a complete small sample to demonstrate the problem, including script to create and fill table.

Mail sent