FieldIndex returns 0 from IE Plug-In

[michael_anthony]

Hi,

I have a field called Currency_Select which is controlled by user (Always One Selected Value checked) and a separate unattached field PrimaryCurrency which has a subset of currencies (eg. AUD, USD and EUR). I want to check whether the selected value in Currency_Select is one of the PrimaryCurrency options.

Working in QV Desktop on the Server I have created an expression:

=

If(FieldIndex('PrimaryCurrency',Only(Currency_Select))>0,Only(Currency_Select),'N/A')

This works fine and returns the expected value. BUT when I look at the same from the IE Plug-in I get N/A as the FieldIndex function fails to work. Does anyone else have similiar problems with FieldIndex, and is there a solution?

Thanks, Michael

[pover]

Never hurts to make sure that the Plug-in, QV Desktop and QV Server are all the same exact version.

Regards.

[rwunderlich]

FieldIndex() had some problems on earlier version of QV9 on the server. What version and SR is your server at?

[michael_anthony]

Still on 8.5 for Developer, QVS and PlugIn. Believe we're at SR6.

I've instead used a work around expression of Count(DISTINCT If(PrimaryCurreny = Only(Currency_Select),PrimaryCurrency)) > 0 to give same outcome.

[rwunderlich · Accepted solution]

Yes, it was definately broken in 8.5. Was fixed sometime in 9. Glad you found a workaround.