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?
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.