Error when parameter type si not defined and param is null

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
brace
Posts: 226
Joined: Wed 14 Feb 2007 08:26

Error when parameter type si not defined and param is null

Post by brace » Tue 02 Aug 2022 14:04

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.

Post Reply