Error when parameter type si not defined and param is null

[brace]

In a TMSQuery with only one parameter of type integer, if the parameter type is not specified in the PAramers section, when I execute the query with null parameter I have:

Invalid input parameter values. Check the status values for detail.

THis occurs only on some machines, while in the others it works.

Which could be the reason?

The workaround is set the parameter type to integer.

I am using SDAC 10.1.1 on Delphi 10 Seattle, the problematic machine is Win Server 2012R2.

Thanks.

[pavelpd]

Hi,
Thanks for contacting our blog!

Kindly note, that we were unable to reproduce the behavior you specified based on the data you provided.

So could please compose and send us an sample application reproducing the behavior you have specified with all necessary DDL and DML scripts to create and populate database objects.
You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html

Also, please send us the exact list of steps (actions) which leading to the error you indicated.
You can create and send us the screenshot demonstrating the issue.

[Ludek]

It is provider dependent. You are apparently using prAuto. Happens with oledb, works with native client. or vice versa, i'm not sure. I am just always filling the parameter data type.

[brace]

Thanks for the replies, I confirm I use prAuto, so I will make sure to avoid undefined type and null param from now on.

Issue solved for me.