Dynamic SQL

[beginflints]

Hello
I have some issue about dynamic sql
In this sample use type parameters are int(can null), I trying to use string and use ".Hasvalue" it doesn't work.

Thank.

[maxtoroq]

Try _If(value != null, ...)

[beginflints]

Do you mean like this?

it doesn't work for me, Or I do something wrong?

[beginflints]

[maxtoroq]

_If(REF_NO != null, ...)

[beginflints]

It work. !!
It's very useful for me.
Thanks for your help!

[beginflints]

Sorry I'm found some error at runtime,
This is my code

Variables

Have some error at runtime

[beginflints]

I'm apologize, it's my fault, I thought is index ({0}>{1}>{2}) use sequentially only,
Now I'm used {0} for first variable each commands.