topic Re: I have this error in SQL instruction in Product Forum

I have this error in SQL instruction

HoffmanGuerra — Fri, 18 Jun 2021 18:46:27 GMT

Hello community,

I have this error and I cann´t solve it.

The instruction is in the first image attached.

Please, some One can help me?

Re: I have this error in SQL instruction

EmersonF — Fri, 18 Jun 2021 19:28:28 GMT

Hi, @Hoffman Guerra try it!

"[ID] = '"&[ItemData.ID]&"' AND [Status] not like 'OK'"

See if this works for you, if this helps you mark as answered

Re: I have this error in SQL instruction

vivek.kumar.goel — Sat, 19 Jun 2021 07:34:24 GMT

Out of curosity, it seems like you are doing an exact match, and hence using "Not Like" is useless.

Probably you should considering "!= or <>" operator which would consume less memory.

Re: I have this error in SQL instruction

EmersonF — Sat, 19 Jun 2021 13:05:15 GMT

Good observation! In fact, the best option would be to use negation <>

Re: I have this error in SQL instruction

HoffmanGuerra — Mon, 21 Jun 2021 18:57:02 GMT

Hello guys,

Thanks for your response, I changed to "<>" and it worked!