[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [ic] UI Table editor use of primary key?


> -----Original Message-----
> From: suppressed 
> [mailto:suppressed On Behalf 
> Of Jeff Boes
> Sent: 2006 May 25 -- Thursday 8:26 AM
> To: suppressed
> 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

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.