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
