Thunderstone Support Forums

I'm trying to set wildoneword thusly:

<sql "set wildsingle='1'></sql>

But it seems to have no effect upon query results. Am I doing something wrong? Does the SQL call have to be at any particular time before the query or does it get lost?

Thanks.Tom

Never mind. I just realized my test query was bad.

If I test with "mutu* fund" I can see the difference when wildsingle is set to 0 vs 1 (in Texis 6)

It does raise a question -- is there a way to dump the current apicp and SQL query settings so I know what is being used at a given point in the script?

In Texis version 6, Vortex has a function <apiinfo thesetting> which will return the current value of the <apicp> setting named `thesetting'; use `settings' to dump all settings. SQL properties are not currently dumpable, AFAIK.