Hi all. If anyone is using sqlYoga and has experience creating query objects that have multiple or statements, gimme a holler offlist if you please. I am trying to build a query object which can find records that have partial matches for a given value in several columns. For instance, if the user types "Murr" into a search field, I want to find all records where sitename contains "murr" or sitecity contains "murr". Get it?
I can actually write the SQL for it, but I am trying to master query objects. I'd like to do as much as I can with sqlYoga without having to revert to the Livecode Database API. Thanks. 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
