GetSchema("Columns") isn't complete

GetSchema("Columns") isn't complete

Postby inTrance » 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
inTrance
 
Posts: 10
Joined: Tue 04 Apr 2006 17:07

Postby Alexey » Mon 13 Nov 2006 08:30

You mean precision and scale? These data is retrived as well.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby inTrance » 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...
inTrance
 
Posts: 10
Joined: Tue 04 Apr 2006 17:07

Postby Alexey » Wed 15 Nov 2006 11:48

Please provide me with your table definition.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby inTrance » 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]
inTrance
 
Posts: 10
Joined: Tue 04 Apr 2006 17:07

Postby Alexey » 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?
Last edited by Alexey on Wed 15 Nov 2006 16:45, edited 1 time in total.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby inTrance » 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
inTrance
 
Posts: 10
Joined: Tue 04 Apr 2006 17:07

Postby Alexey » 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby inTrance » 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
inTrance
 
Posts: 10
Joined: Tue 04 Apr 2006 17:07

Postby Alexey » Tue 28 Nov 2006 07:49

We have fixed this for you. Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL