Autoincrement results in a 0 value

I have the same table defined in multiple catalogs.  The table contains 
a primary key that is set to auto-increment.  In some of the tables, 
auto-increment works fine.  In certain others, the table column that 
should be auto-incrementing returns a 0 value.  Can anyone help?  The 
tables are ISAM. 

The table definition is:  "CREATE TABLE version (refNo BIGINT NOT NULL 
AUTO_INCREMENT,  revYear INT NOT NULL, sequence INT NOT NULL,  revDate 
DATETIME,  PRIMARY KEY (refNo), INDEX dateIdx(revDate),  INDEX serNoIdx 
(sequence))  ENGINE = MYISAM  CHARACTER SET utf8 COLLATE utf8_general_ci

Thanks
Gary


-- 
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@xxxxxxxxxxx