SQL Provider : "Invalid input parameter values. Check the status values for detail" when using Date types parameters

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

SQL Provider : "Invalid input parameter values. Check the status values for detail" when using Date types parameters

Post by swierzbicki » Mon 05 Jan 2015 15:21

Hello,

I'm getting "Invalid input parameter values. Check the status values for detail" when using "Date" type parameters.

SQL Server is running a French SQL Server 2012 edition.

My query is something like

Select *
from
MyView
Where
Activity_Date between :Activity_Date_Begin and :Activity_Date_End

What can I do ?
Top
azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: SQL Provider : "Invalid input parameter values. Check the status values for detail" when using Date types parameters

Post by azyk » Tue 06 Jan 2015 08:55

Unfortunately, we couldn't reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to andreyz*devart*com, including a script to create test tables.
Top
Post Reply

Return to “Universal Data Access Components”