Thunderstone Support Forums

Is it correct that LIKEP queries return rows in descending order by rank (assuming there is not an order by clause)? In other words, it isn't necessary to select $$rank as Rank and order by Rank desc.

Correct; LIKEP orders by rank by default.

Another question: how long do explicit rank knobs and properties setting last? Do they have to be reset before each query in a script? For example I have a function which performs a likep query. Prior to running the query, however, I call a private function to perform a query with the same conditions, but selecting only count(*), so I have an accurate record count. If I set likepallmatch and likeprows in the provate function, will they still be in effect when control returned to the calling function?

Yes; <SQL "set ..."> settings remain in effect for the life of the script generally; some may be reset by a <sqlcp cache close> however.