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
_______________________________________________
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
