Problem with LargeInt in myDac 4.40.0.25

saidus · Post by **saidus** » Mon 07 Jul 2008 08:55

Hello Devart !!
first let me show you this little script :

CREATE TABLE `loclient` (                                
            `loCode` int(15) NOT NULL auto_increment, 
            `loNom` varchar(50) default NULL,                      
            `loPrenom` varchar(50) default NULL,                   
            `loAdresse` text,                                      
            `loZCode` varchar(5) default NULL,                     
            `loVille` varchar(50) default NULL,                    
            `loTelephone` varchar(20) default NULL,                
            `loTelephoneHome` varchar(20) default NULL,            
            `loBt_0_5` int(5) default NULL,                        
            `loBt_1_5` int(5) default NULL,                        
            `loBt_2_0` int(5) default NULL,                        
            `loBt_5_0` int(4) default NULL,                        
            `lo_MagicNumber` int(15) unsigned default NULL,        
            PRIMARY KEY  (`loCode`),                               
            UNIQUE KEY `lo_MagicNumber` (`lo_MagicNumber`)         
          ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

CREATE TABLE `lobouteille` (
`CodeBt` int(15) unsigned NOT NULL auto_increment,
`loCode` int(15) default NULL,
`Bouteille` varchar(20) default NULL,
`Couleur` varchar(50) default NULL,
`Qtes` int(10) default NULL,
PRIMARY KEY  (`CodeBt`),
KEY `FK_lobouteille` (`loCode`),
CONSTRAINT `FK_lobouteille` FOREIGN KEY (`loCode`) REFERENCES `loclient` (`loCode`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

When I go to delphi , I drop 2 TMyQuery in Datamodule then I connect them to the respective tables (loClient an loBouteille) then I generate a script (select , insert ...)..
Problem is when i invoke the field editor ,
for the first table (loClient )it generate for field (loCode ) the type TLargeIntegerField and for the second table(loBouteille) the field (loCode )is generated as TIntegerField so it dont allow me to realise the master-detail relashion...
is it a bug from MyDac ...

I use Delphi7 + mydac 4.40.0.25 + mysql 5.0.51b-community-nt General release

Thanks for comprehension

saidus · Post by **saidus** » Mon 07 Jul 2008 08:58

saidus wrote: I use Delphi7 + mydac 4.40.0.25 + mysql 5.0.51b-community-nt General release

I mean Delphi7 + MyDac 4.40.1.24 + mysql 5.0.51b-community-nt General release

Antaeus · Post by **Antaeus** » Mon 07 Jul 2008 10:48

I could not reproduce the problem.
Please send us a complete small sample at mydac*crlab*com to demonstrate it.

saidus · Post by **saidus** » Mon 07 Jul 2008 11:42

OK I will send you soon

saidus · Post by **saidus** » Mon 07 Jul 2008 11:57

I dont understand but it work well
Excuse me !!!

Devart Forums

Problem with LargeInt in myDac 4.40.0.25

Problem with LargeInt in myDac 4.40.0.25

Re: Problem with LargeInt in myDac 4.40.0.25