Database syntax

Bob Sneidar bobs at twft.com
Tue Dec 20 17:52:47 EST 2011


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





More information about the Use-livecode mailing list