DateField problem with you last build

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Zagawa
Posts: 21
Joined: Fri 12 May 2006 09:56

DateField problem with you last build

Post by Zagawa » Thu 14 Dec 2006 09:03

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.

Zagawa
Posts: 21
Joined: Fri 12 May 2006 09:56

Post by Zagawa » Thu 14 Dec 2006 09:20

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'.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 15 Dec 2006 08:03

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
8) 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.

Zagawa
Posts: 21
Joined: Fri 12 May 2006 09:56

Post by Zagawa » Fri 15 Dec 2006 09:20

Mail sent :)

Post Reply