Multi-value SQL Parameters and strlst Changes, arrayconvert - Caveat

In Texis version 6, <sqlcp arrayconvert> (here) was added, and is on by default. This expands strlst values from SQL into individual varchar values when returned in Vortex variables, and converts Vortex multi-value varchar parameters to strlst when passed to SQL (and Metamorph treats strlst queries as an equiv list). In version 5, multi-value varchar parameters were passed as a varchar parenthetical list instead (i.e. a Metamorph search was always assumed).

Caveat: This can affect the return values of <sql> statements, and cause returned column variables to become out-of-sync row wise.

To restore version 5 behavior by default, set the texis.ini setting [Texis] Array Convert to off.


Copyright © Thunderstone Software     Last updated: Oct 24 2023
Copyright © 2024 Thunderstone Software LLC. All rights reserved.