Wrong Datatype in Custom Query Variable

[turn3636]

In my custom query, I am using a filter parameter and in the output, it’s telling me it is the wrong datatype “Conversion failed when converting nvarchar to init.”

How do I change the data type?

Here is my variable and it is a number:

Here it is in my custom query, as a filter parameter:

Here it is in my database:

But in the output it is trying to convert it:

Where can I change that? Where does it get nvarchar from? I have never had that datatype.

Thanks,
Chris

[patrick]

dbupdater.zip (1.1 KB)

See if this update solves it. Replace file in dmxConnectLib/modules.

[turn3636]

I will try that, thank you very much.

[turn3636]

Patrick, that did it. Many thanks.

[Teodor]

Fixed in Wappler 2.4.5