[ic] UI Table editor use of primary key?

[Daniel Davenport]

> -----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.  :)

--
Daniel Davenport
New Age Digital
http://www.newagedigital.com