[ic] UI Table editor use of primary key?
Stefan Hornburg
racke at linuxia.de
Thu May 25 14:53:53 EDT 2006
On Thu, 25 May 2006 10:23:08 -0400
"Daniel Davenport" <DDavenport at newagedigital.com> wrote:
> > -----Original Message-----
> > From: interchange-users-bounces at icdevgroup.org
> > [mailto:interchange-users-bounces at icdevgroup.org] On Behalf
> > Of Jeff Boes
> > Sent: 2006 May 25 -- Thursday 8:26 AM
> > To: interchange-users at icdevgroup.org
> > Subject: [ic] UI Table editor use of primary key?
> >
> > I added a sequence-based primary key to a table that
> > previously had no primary key. How do I get the table editor
> > to use that new column as the linking field? It continues to
> > link to the editing page with the first column in the table
> > (which is not unique).
>
> If possible, you'll probably want to put the new field at the beginning
> of the table. A lot of IC stuff assumes the first column to be the key,
> and ignoring that assumption can sometimes cause you more headaches than
> it's worth.
>
> If you want to try, though, you can say
>
> Database mytable KEY mynewkeyfield
>
> to tell IC which field ought to be the ID field. Just don't say you
> weren't warned. :)
In fact, if that KEY definition doesn't work as expected, it would be
a bug. I'm using it regularly and never encountered a problem.
Bye
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users
mailing list