Use of ParameterRR

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

Use of ParameterRR

Post by noodles » Mon Oct 27, 2003 9:43 pm

I have a simple report with just a master table. It has a column (Character field of size 4) which I would like to use in the report filter.____I want to create a ParameterRR field representing a user input value which the column will be compared to. i.e. select the record if cloumn is equal to my ParameterRR field. I construct the report filter accordingly.____I create the ParameterRR field with a default value, say "ABCD" (including double quotes as instructed). When I run the report, I enter an alternate value in the ParameterRR Value Entry Dialogue.____I then receive and ODBC-based error stating that I have an invalid column name equal to the new value that I enter for the ParamaterRR field.____Checking the SQL I see that the where clause has the form AAAA."bbbb" = "CCCC"__ where AAAA is the alias for my table__ bbbb is the table attribute__ CCCC is the value entered in the ParameterRR entry____If I change my report filter to have the column caompred to a constant value, the SQL has the form AAAA."bbbb" = ^CCCC^____It is obviously the double quotes around my test value that causes the SQL syntax problem.____What changes to my report definition can I make to be able to utilise the ParameterRR field for comparison?__
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Use of ParameterRR

Post by kfleming » Tue Oct 28, 2003 8:52 am

Define the parameteRR field default value using single quotes rather than double quotes and things should work correctly.____Kathleen__R&R Support
Top
noodles
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Use of ParameterRR

Post by noodles » Tue Oct 28, 2003 7:41 pm

I changed the Default Value to a character value with single quotes. The SQL generated appears exactly the same with the compared value surrounded in double quotes. The same error ^Invalid Column Name^is reported.____I am using the Pervasive ODBC Engine Interface V7.94.251.02__
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Use of ParameterRR

Post by kfleming » Tue Oct 28, 2003 10:52 pm

Are you using the latest 10.1.003 release?____Kathleen__R&R Support
Top
noodles
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: Use of ParameterRR

Post by noodles » Thu Oct 30, 2003 1:26 am

Using R&R for Windows SQL Edition Version 10.0, Build 10.0.010
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=====> RE: Use of ParameterRR

Post by kfleming » Thu Oct 30, 2003 8:01 am

Try downloading the 10.0.012 update.____Kathleen__R&R Support
Top
noodles
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

======> RE: Use of ParameterRR

Post by noodles » Tue Nov 04, 2003 5:48 pm

Loaded 10.0.012 update. Appears to be working OK now.____Many thanks for your assistance__
Top
Post Reply

Return to “R&R ReportWorks Users”