On 3/19/06, shreeseva <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: shreeseva > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Sent: Monday, March 20, 2006 01:15 AM > Subject: About Data types > > > Dear friends, > I am using MySQL 5.0.17 on Win XP Prof. I have created a prototype database > design in Ms Access 2003 and using MySQL Migration tool uploaded this to > MySQL server. I have encounterred few problems with it. > 1) Migration toolkit successfully transfered all tabels and indexes but all > Autonumber fields are transfered as 'int'. Also all boolean fields(In Access > 'Yes/No' ) are transfered as 'tinyint'. Is there a bug the toolkit?
No. Try to familiarize yourself with MySQL a bit, and read some manual pages. An "autonumber" field in Access is a number. In MySQL an "autonumber" field looks like this: int unsigned not null auto_increment primary key So int is correct. As well, the manual page for the BOOLEAN type (try http://www.mysql.com/boolean) says that real booleans aren't supported, it just uses tinyint(1) to store the values. So that is correct, no bug in the toolkit there. > 2) When I go for data entry through Access form It displays as '#deleted' in > all fields. Why? Are you asking a question about MS Access? -Sheeri > I am entering data from Master form and when control goes into the Subform > linked with the master form it makes all entered fileds as '#deleted'. The > master form is related with documents table having one field as AutoIncrement > and subform is based on Transactions for that document. This Transactions > table also contains one Autoincrement filed. Both such fileds are PK's also. > Now when I changed the AutoIncrement to 'No' for Documents table it goes > correctly and not displayed '#deleted'. But when I entered data into > Transactions table having AutoIncrement still to 'Yes' then it displayed as > '#deleted'. Why? > Is this a bug or my mistake or ODBC driver problem or Access problem? > > Please help > Thanks and regards. > > CPK > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
