FillSchema returns no Default value

FillSchema returns no Default value

Postby Florian Heinemann » Wed 30 Aug 2006 20:12

Hello!

We're using FillSchema to retrieve standardized table information. Unfortunately is the value "DafaultValue" not set... So we have to write special code for MySQL using GetSchema to get the default information. Is there a way to force MySqlDirect to fill in the DefaultValue column?

Regards,

Florian Heinemann
Florian Heinemann
 

Postby Alexey » Thu 31 Aug 2006 07:16

To retrieve DefaultValue use MySqlConnection.GetSchema method.
For example,
Code: Select all
DataTable myTable = mySqlConnection1.GetSchema("Columns", new string[] { "Test", "emp" });
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL