D
dbeavon
Guest
>> difference between Jon Brock's example and my example is that you have not to know the value of the parameter before the Query-prepare True. Although once Jon started using a temp-table, it seemed to imply that the query was re-usable too (with new parameter values). It would be a cruel thing if the query could *not* be used again, despite the referencing of the temp-table. In my follow-up post I pointed out that you ... "can even close and reopen the query without repeating the QUERY-PREPARE operation". Thanks for the additional sample code. This is helpful. It is too bad the docs don't make it clear that this is the (only?) way to create parameterized dynamic queries that don't need to be constantly recompiled. Many scenarios for using "dynamic queries" would perform much better if they didn't need to be recompiled whenever the parameter data is changing.
Continue reading...
Continue reading...