On Thu, 25 May 2006 10:23:08 -0400 "Daniel Davenport" <suppressed> wrote: > > -----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. :) 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 _______________________________________________ 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.