Thanks for all the suggestions on this issue. I finally resorted to dumping my data, creating a new db using Valentina Studio, and loading the data back in. Worked like a charm. I’m back in business. The original file was created with an older version of SQLite, so I’m guessing that had something to do with it. Not sure why an issue like this would happen, but glad it’s working again.
Thanks, Chris On Mar 12, 2014, at 7:18 PM, Kay C Lan <lan.kc.macm...@gmail.com> wrote: > Try creating a brand new db and see if you can get WHERE clauses to work. > If so, what about dumping your data, build a new db and see if that works? _______________________________________________ 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