Database syntax

Bob Sneidar bobs at twft.com
Tue Dec 20 15:39:39 CST 2011


On Dec 20, 2011, at 12:51 PM, Michael Doub wrote:

> I need to go lookup the details of the default key word.   If I use it would the above syntax be 
> simplified to:
> 
> put  "INSERT into ContactData (" & \
>            "RecordType," & \
>            "DataArray) " & \
>            "Values (:1,:2 )" into tUpSQL
>      put the pNetDB of stack "MyNetwork" into sNetConnID
>      put empty into x
>      put 0 into tRT
>      revExecuteSQL sNetConnID, tUpSQL,"tRT","*btSettings"
> 
Yes it would, so long as the default is what you want for new records. 

> Can I use this substitution trick with any SQL statement, specifically the updating?

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. 

Are arrays on mobile devices more memory intensive than an sqLite database? 

Bob





More information about the use-livecode mailing list