Page 1 of 1

Default column values

Posted: Mon 07 Nov 2005 13:41
by fja
Hi,

On my MySql server is the tabel fields set up vith default values. If I make a insert to the dataset for the table I would like to see the default values i eg. my dbgrid. Is it an option I have overseen or how can I do it?

It is not a MySQL issue because when I use Navicat to insert a value i the same table it works fine.

Can anyone please help me.

Flemming

Posted: Tue 08 Nov 2005 08:13
by Ikar
Set TCustomMyDataSet.Options.DefaultValues property to True.

Posted: Tue 08 Nov 2005 12:48
by fja
Hi,

I am using MyDac ver 3.55 for Dephi 7. Is this a new feature for ver 4.00 because I can't find this property.

Flemming

Posted: Tue 08 Nov 2005 14:37
by Ikar
Yes, it is MyDAC 4.0 feature.

Posted: Tue 08 Nov 2005 14:53
by fja
Hi,

Ok! If I upgrade to MyDAC 4.00 will I get problems with SDAC ver 3.55. Because when I upgraded from MyDAC 2.xx to 3.xx it caused problems with my SDAC and I had to upgrade SDAC as well.

Flemming

Posted: Wed 09 Nov 2005 08:19
by Ikar
To avoid the problem, you should download latest versions of MyDAC and SDAC.
Currently they are 4.00.1.6 and 3.55.1.20 accordingly.
As registered user of SDAC 3.55 you can download SDAC 3.55.1.20 for free.

Posted: Wed 09 Nov 2005 08:24
by fja
Thanks

I will order/download MyDac 4.00


Flemming