Default column values

fja · Post by **fja** » Mon 07 Nov 2005 13:41

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

Ikar · Post by **Ikar** » Tue 08 Nov 2005 08:13

Set TCustomMyDataSet.Options.DefaultValues property to True.

fja · Post by **fja** » Tue 08 Nov 2005 12:48

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

Ikar · Post by **Ikar** » Tue 08 Nov 2005 14:37

Yes, it is MyDAC 4.0 feature.

fja · Post by **fja** » Tue 08 Nov 2005 14:53

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

Ikar · Post by **Ikar** » Wed 09 Nov 2005 08:19

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.

fja · Post by **fja** » Wed 09 Nov 2005 08:24

Thanks

I will order/download MyDac 4.00

Flemming