Yes I did in fact, but I have decided that for purposes of searching, I want to work with a fixed data set. When a form is opened I want to load the data as it is at the time the form is opened. There will be a refresh option as well, and before I save data, I do verifications which include no time and date collisions for scheduled data, and no duplicates for unique fields.
At some point in the future I will probably want to make a mobile app for what I am doing, and efficiency in data usage, especially considering most provider's strict rules involving bandwidth usage will be paramount. Bob On Jun 18, 2012, at 10:38 AM, Peter Haworth wrote: > Hi Bob, > Have you taken into account that the data you are filtering may be out of > date by the time it gets filtered in memory because data was either added, > changed, or deleted in your database? > > That's an application-dependant issue of course so maybe it either doesn't > matter or can't happen in your app. > > Pete > lcSQL Software <http://www.lcsql.com> > > > > On Mon, Jun 18, 2012 at 10:00 AM, Bob Sneidar <b...@twft.com> wrote: > >> Hi Dick. >> >> For simple arrays this will work well. I am envisioning large datasets, >> and I want to filter based upon a substring being present in a list of >> columns I provide. The goal is to create a comprehensive find field that >> works much the way a Spotlight search works, only on SQL data. >> >> Some will say, "Why not just query your SQL database over and over?" Good >> point, but the process of requerying a database, particularly one like >> On-Rev's from a remote location seems a little too much, but it does bring >> up an interesting point: What if I can save an array as a memory based >> sqLite table (it would have to be very specific in it's structure, say a 2 >> dimensional array like the one a Datagrid uses) and then I could query the >> sql table extremely quickly. >> >> This is the line I am taking at present. >> >> Bob _______________________________________________ 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
