How to retrieve MySQL field Default value ?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

How to retrieve MySQL field Default value ?

Post by swierzbicki » Thu 19 May 2005 10:04

Hi,

When I've designed my table, I've set default value on some fields.

Now, when inserting a new row, default values aren't fetched. Am I missign something (a property to set) or MyDac isn't capable to retreive default values ?

Thank You.

Best Regards,

Stéphane Wierzbicki

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 19 May 2005 15:35

MyDAC doesn't provide such functionality. We are planning to add it but not at the nearest time.

swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

Post by swierzbicki » Thu 19 May 2005 15:54

Ok, it's good to know it.
I will try to handle my problem on a different way :)

Best Regards,

Stéphane Wierzbicki

GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:

Post by GEswin » Thu 19 May 2005 23:19

Hi

I would like to see this feature too, right now I do a Refresh of record after first post, so i can see default values, but this approach is not best way. I would prefer to see default values after an append/insert.

swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

Post by swierzbicki » Mon 23 May 2005 07:46

Hi,

Ikar, is there a date planned for this feature ?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 23 May 2005 13:36

> Ikar, is there a date planned for this feature ?

Not yet, now I cannot tell you when exact it will be added.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 02 Jun 2005 11:09

We added support of getting Default Values. Look forward for beta version, we are planning to release it this week.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 06 Jun 2005 13:11

New build was released and you can download it (4.00.0.1 Beta) now from Core Lab server.
For more details about different reasons of this error occurrence please see http://crlab.com/forums/viewtopic.php?t=1359

Post Reply