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 <[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
