I'm not sure I follow that logic :-) What's the point of autoincrement if he has to supply the primary key value and how does he get the next available primary key value for the insert?
On Tue, Dec 20, 2011 at 12:50 PM, Bob Sneidar <b...@twft.com> wrote: > I should probably also mention that it would be better to set all your > column values in the insert statement. Otherwise you will have to query for > the last inserted primary key and use that in your next UPDATE statement's > WHERE clause. -- 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