[ic] autonumber with mySQL

Grant 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
> AUTO_INCREMENT
> > 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.
>
> Bye
> 	Racke

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?

- Grant



More information about the interchange-users mailing list