Oh right duh that makes sense. I have no idea where I got that. Bob
On Jan 17, 2012, at 11:47 AM, Pete wrote: > 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 _______________________________________________ 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
