In our Vortex scripts we often precede calls to <sql> with calls to <apicp> to set one parameter or another for the sql call to follow. In some of those sql calls I'm now wanting to override the default database by (i.e., the one set with <db>) using
<sql db=$theNonDefaultDb ...>
Do the calls to apicp that precede this apply to the default database or to the database specified in the <sql> call? That is, is it necessary to do something like this instead:
<db=$theNonDefaultDb>
<sql ...>
<db=$theDefaultDb>
which seems just ever so lightly less elegant!
Thanks.
<sql db=$theNonDefaultDb ...>
Do the calls to apicp that precede this apply to the default database or to the database specified in the <sql> call? That is, is it necessary to do something like this instead:
<db=$theNonDefaultDb>
<sql ...>
<db=$theDefaultDb>
which seems just ever so lightly less elegant!
Thanks.