Hi Bob, I don't think that's true. I think you can have it not autoincrement and supply the primary key value yourself when you insert a row. In fact, you have to do that if the primary key is one of the text data types since autoincrement doesn't make any sense in that context. Pete
On Mon, Jan 16, 2012 at 1:25 PM, Bob Sneidar <b...@twft.com> wrote: > It's my understanding that a primary key MUST be AI in mySQL. A friend of > mine gave me a query that will find the next available value in a column of > numbers: -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode