[ic] UI Table editor use of primary key?
Daniel Davenport
DDavenport at newagedigital.com
Thu May 25 10:23:08 EDT 2006
> -----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
More information about the interchange-users
mailing list