|
| Iniciado por guest, 10,jul. 2016 21:27 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 10,julio 2016 - 21:27 |
Hi all
Struggling with syntax for getting a list of fields
Need list of options passed by parameter
HFilter(FIXNAMES,ACCNO,"4-0000","9-9999","left(ACCDESC,3) = 'Hea'") // works fine
But need a list
HFilter(FIXNAMES,ACCNO,"4-0000","9-9999","left(ACCDESC,3) in ['HEA','NSW','MAN']" )
to finally get
sList is string = "'ABC','DEF',GHI'"
HFilter(FIXNAMES,ACCNO,"4-0000","9-9999",stringbuild(left(ACCDESC,3) in %1",sList )
Any help appreciated.
Thanks
Mark |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,julio 2016 - 22:28 |
Solved myself.
sString is string = "'Hea','VIC'"
HFilter(FIXNAMES,ACCNO,"4-0000","9-9999",StringBuild("left(ACCDESC,3) in (%1)",sString ))
HReadFirst(FIXNAMES)
TableDisplay(Table_FIXNAMES,taStart) |
| |
| |
| | | |
|
| | | | |
| | |
|