[ic] UI Table editor use of primary key?

[Stefan Hornburg]

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