Devart Forums

Posted: **Sat 11 Nov 2006 12:38**

Hello!

We use GetSchema("Columns") to retrieve table details. But there is at least one important flag missing: The decimal count of a double/decimal/float like "double (7,3)"

Is there any other possibility to get this information without using selfmade-SQL-Scripts? And do you want to add this flag to the schema?

Regards,

Sven Kolber

Posted: **Mon 13 Nov 2006 08:30**

You mean precision and scale? These data is retrived as well.

Posted: **Tue 14 Nov 2006 16:09**

Unfortunately not in my case. I have the following field in a table on a MySQL 5.0 server:

Code: Select all

spesen      double(20,10)  (NULL)           NO              13.9000000000

This field fills Precision with 20 and Scale with 0...

Posted: **Wed 15 Nov 2006 11:48**

Please provide me with your table definition.

Posted: **Wed 15 Nov 2006 15:12**

Here is an other example on a 5.0 server:

Table definition

Code: Select all

CREATE TABLE `products` (                          
            `ProductID` int(11) NOT NULL auto_increment,     
            `ProductName` varchar(40) NOT NULL,              
            `SupplierID` varchar(20) default NULL,           
            `CategoryID` decimal(12,3) default '0.000',     // <------- 
            `QuantityPerUnit` smallint(6) default '0',       
            `UnitPrice` smallint(6) default '0',             
            `UnitsInStock` smallint(6) default '0',          
            `UnitsOnOrder` tinyint(4) NOT NULL default '0',  
            PRIMARY KEY  (`ProductID`)                       
          ) ENGINE=MyISAM DEFAULT CHARSET=utf8

The result of MySQLDirect is:

Precision: 12
Scale: 0 (should be 3)

Regards[/b]

Posted: **Wed 15 Nov 2006 16:30**

I cannot reproduce the error. Schema is rettrived correctly. What are the full versions of MySQL Server and MySQLDirect .NET?

Posted: **Wed 15 Nov 2006 16:43**

Alexey wrote:I cannot reproduce the error. Schema is rettrived correctly. What is the full versions of MySQL Server and MySQLDirect .NET?

Latest MySQLDirect version (.14)
Windows MySQL Server: 5.0.15

Posted: **Wed 15 Nov 2006 17:27**

We are investigating this problem with your particular version.
You will be notified on results as soon as possible.

Posted: **Mon 27 Nov 2006 18:00**

Alexey wrote:We are investigating this problem with your particular version.
You will be notified on results as soon as possible.

Do you have some results?

Regards

Posted: **Tue 28 Nov 2006 07:49**

We have fixed this for you. Look forward to the next build.

Devart Forums

GetSchema("Columns") isn't complete

GetSchema("Columns") isn't complete