You can update as many records as you want in one instruction as long as you can identify them in a WHERE statement:
UPDATE tablea SET field1="newvalue" WHERE tablea.fielda="oldvalue" Pete Molly's Revenge <http://www.mollysrevenge.com> On Wed, May 18, 2011 at 8:55 AM, Bob Sneidar <b...@twft.com> wrote: > I was under the impression you could only update one record at a time in > SQL. Sure you can stack queries together and send them all at once (I guess > that would be quicker). Is there a limit on the size of a SQL statement? > > Bob > > > On May 17, 2011, at 11:56 PM, Terry Vogelaar wrote: > > > Whether you change record after record, or 50 in one step, depends on the > values. It is certainly possible to write a massive SQL instruction. But it > might save your sanity when you change them one by one in a repeat loop, > with a much simpler SQL query. However, if those 50 records can be filtered > easily, and if they share values, combining might make sense. Hard to say. > > > > Terry > > > _______________________________________________ > 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 > > _______________________________________________ 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
