[ic] autonumber with mySQL
listbox at email.com
Wed Jan 14 15:48:03 EST 2004
> On Wed, 14 Jan 2004 11:50:48 -0800
> "Grant" <listbox at email.com> wrote:
> > Hello, I'm trying to set up a new table (correspondence) that will
> > "autonumber" a new key every time a new record is written. I
> have this in
> > my correspondence.mysql file:
> > Database correspondence COLUMN_DEF "code=INT(5) UNSIGNED
> > PRIMARY_KEY"
> > and this in my catalog.cfg
> > Database correspondence AUTO_SEQUENCE 1
> > The correspondence.txt file is set up with field names, but
> when I restart I
> > get the following errors:
> > table correspondence index failed: Table
> 'catname.correspondence' doesn't
> > exist
> > table 'correspondence' failed: Table 'catname.correspondence'
> doesn't exist
> > A correspondence.autonumber file is created, but no correspondence.sql .
> > Can anyone tell me what I'm missing?
> Isn't your problem pretty obvious ? Take a look at the first line of any
> *.mysql file of current foundation.
It's not obvious to me. The first line of the Foundation products.mysql
file I have is:
Database products products.txt __SQLDSN__
and the first line of my correspondence.mysql file is:
Database correspondence correspondence.txt __SQLDSN__
That all looks good to me. Should I be naming this table
catname.correspondence instead of correspondence?
More information about the interchange-users