Default column values

Default column values

Postby 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
fja
 
Posts: 4
Joined: Thu 11 Nov 2004 08:56

Postby Ikar » Tue 08 Nov 2005 08:13

Set TCustomMyDataSet.Options.DefaultValues property to True.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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
fja
 
Posts: 4
Joined: Thu 11 Nov 2004 08:56

Postby Ikar » Tue 08 Nov 2005 14:37

Yes, it is MyDAC 4.0 feature.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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
fja
 
Posts: 4
Joined: Thu 11 Nov 2004 08:56

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby fja » Wed 09 Nov 2005 08:24

Thanks

I will order/download MyDac 4.00


Flemming
fja
 
Posts: 4
Joined: Thu 11 Nov 2004 08:56


Return to MySQL Data Access Components