String comparison in script?
Hello,
In the following script the <frxDBDatasetArajanlat."av_penznem_rovidites"='HUF' causes an error.
I tried with double quotes, with ==, but I still get the error.
(if I compare a numeric field it works e.g. field > 1, but with string field it doesn't)
Nett??: [sum( (IIF(<frxDBDatasetArajanlat."av_penznem_rovidites"='HUF', <frxDBDatasetArajanlatSorok."avs_mennyiseg">*<frxDBDatasetArajanlatSorok."avs_vevoar"> ,
<frxDBDatasetArajanlatSorok."avs_mennyiseg">*<frxDBDatasetArajanlatSorok."avs_vevoar">/100)) )]
Thank you very much
In the following script the <frxDBDatasetArajanlat."av_penznem_rovidites"='HUF' causes an error.
I tried with double quotes, with ==, but I still get the error.
(if I compare a numeric field it works e.g. field > 1, but with string field it doesn't)
Nett??: [sum( (IIF(<frxDBDatasetArajanlat."av_penznem_rovidites"='HUF', <frxDBDatasetArajanlatSorok."avs_mennyiseg">*<frxDBDatasetArajanlatSorok."avs_vevoar"> ,
<frxDBDatasetArajanlatSorok."avs_mennyiseg">*<frxDBDatasetArajanlatSorok."avs_vevoar">/100)) )]
Thank you very much
Comments
I found the solution. I needed to put > sign.