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 <[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
