ParameterRR on SQL

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Chris_Barnes
Posts: 25
Joined: Tue Oct 10, 2017 12:44 pm

ParameterRR on SQL

Post by Chris_Barnes » Tue Jun 29, 2004 8:48 am

We are currently in the process of rejigging all of our R&R reports to run on the SQL version of R&R10.0.____We currently use ParamRR fields to select dates, when we convert the reports and try to run them we get a "Conversion of CHAR Data Type to DATETIME" message. Is there anyway round this?____TIA____Chris__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: ParameterRR on SQL

Post by kfleming » Tue Jun 29, 2004 7:47 pm

In Xbase did you have a parameteRR field that was date data type that was used in a query comparison with a database date field and now the report is converted to SQL?____Kathleen__R&R Support

Chris_Barnes
Posts: 25
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: ParameterRR on SQL

Post by Chris_Barnes » Wed Jun 30, 2004 6:21 am

Hi Kathleen,____Got it in one. I suspect that because DATETIME fields in SQL Are interpreted as dd/mm/yyyy hh:mm:ss that there is a conflict between the param field and the actual data field on the SQL Server, but we^re not sure how to resolve it.____

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: ParameterRR on SQL

Post by kfleming » Wed Jun 30, 2004 7:52 am

You can create a parameteRR field whose datatype is datetime.____Kathleen__R&R Support

Post Reply