Oh I thought he was talking about defaults. I see what he meant by substitution trick.
Bob On Dec 20, 2011, at 2:09 PM, Pete wrote: > You can use the :1, :2, etc syntax for updates as well as inserts, > irrespective of how many columns you are updating. > > > > On Tue, Dec 20, 2011 at 1:39 PM, Bob Sneidar <b...@twft.com> wrote: > >> No just inserts. After that you only need to include columns that have >> altered in your SQL statements, if you are concerned about efficiency, >> although the statements themselves use very little bandwidth. What will use >> bandwidth is select statements that return large data sets, but I don't >> think that will be an issue for you. > > > > > -- > 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 _______________________________________________ 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