I have a data window which has as stored procedure as its data source. The parameter passed to the stored procedure is of type datetime. In the datawindow design mode and when previewing, the data is properly retrieved on entering the datetime parameter.
However when this datawindow control is embeded in a window and data is retrieved by passing a datetime parameter through script, the retrieve fails and the error mentioned as below is displayed
Select Error: SQLSTATE =22005
[Microsoft][ODBC SQL Server Driver] Invalid character value for cast specification
I am unable to resolve the problem. I am using PB10 eval version. Please help