executes a fuzzy query using a FuzzySQL object
resultHandle = DbFuzzyQuery(fuzzySQL, queryString)
FuzzySQL pointer object, returned by either DbFuzzyLoadFMB() or DbFuzzyCreateFMB() functions
A fuzzy query in FSQL language.
DbFuzzyQuery(...)
Executes fuzzy query in a FSQL language. Returns resultHandle. The
behavior is much the same as one of DbQuery(...) function, but instead
dbConnection object a FuzzySQL object is required, and a query is first
translated to a raw SQL query from FSQL, and then executed, if it
was correct (as for fuzzy object usage).
// Opens a “PostgreSQL” connection with a structure connexionStruct = struct(); connexionStruct.provider = "postgresql"; connexionStruct.database = "myDataBase"; connexionStruct.hostname = "127.0.0.1" ; connexionStruct.use = "myUsername"; connexionStruct.password = "myPassword"; DbConnect(connexionStruct); //creating FuzzySQL object on default connection; fuzzySQL = DbFuzzyLoadFMB(); //Executing a fuzzy query in FSQL resultHandle = DbFuzzyQuery(fuzzySQL, "SELECT * FROM Person WHERE Height FEQ $tall THOLD 0.7"); | ![]() | ![]() |