Suppress variable replacement

FinalBuilder Discussion
1

Hi,

I have sql script that contains '%something%' with LIKE clause. I found that, FB will try to evaluate it in MSSQL Execute SQL action. However, since it is not actually a variable, the'%something%' is replace with empty string.

Anyway to suppress variable replace in this case?

Thank you

2

Yes,

you need to escape the % characters with another %, eg : ‘%%something%%’

3

Hi,

I tried to change my sql script as below, but FB still replace it with ''.

ame like '%%nobalshare%%'

4

Hi Chan,

The escaping is working fine for us - can you please send us an example project that shows the behaviour you’re seeing? Please send to support at finalbuilder dot com

thanks.

5

Hi,

I have sent my FB project and sample script to support@finalbuilder.com two days ago. Hope you have recieve it and hear your reply soon.

 

Thank you

6

Hi Chan,

Thanks for the heads-up. We have received the file, and will get back to you with an answer soon.

Regards,

Angus

7

Hi Chan,

You have a reply via email.

Regards,

Angus