Desktop productivity for business analysts and programmers

error while creating prompts

Posts: 0

error while creating prompts


I have Created A prompt on my date field column which automatched_date and the format is ddmmyy10.
There are two prompts start and end date.
I have craeted these promts using parameter manager in Enterprise Guide.
when I run my project it runs sucessfully but when i create an Stored Process i getting the error

The parameter 'Automatched Date To' is defined to be enclosed in quotes; however, this is not supported by the stored process parameter model.

The parameter 'Automatched Date From' is defined to be enclosed in quotes; however, this is not supported by the stored process parameter model.

kindly tell me the solution
Posts: 8,721

Re: error while creating prompts

As a rule of thumb, I hardly ever specify my Enterprise Guide parameters to be enclosed in quotes, as I prefer to modify my program code accordingly -- use quotes where they're needed or don't use quotes where they're not needed. It seems to me that your best bet for help with this is to contact Tech Support. You have two issues -- how parameters work inside the world of EG and then how input parameters work in stored processes. The fact is that you may have to slightly modify your code when you create a stored process from your EG parameterized task.

Partly, Tech Support will have to look at the selection code in your stored process and help you figure out the best way to specify the parameter. Even if you specify the Date type for your input parameter (in the stored process) in order to get the little calendar box to come up (for the stored process prompting), the value that's being sent will still be a text string. (01OCT2007 versus 17440 -- which is the "internal" number for today as a SAS numeric date value);

This may be slightly different than how you were dealing with things in the parameter manager in EG. But, the bottom line is that you probably want to uncheck the box for automatic quoting and deal with the need for any quotes in your code or your generated code (by inserting code into your task). Tech Support can help you with that task by identifying the correct type of the variable in your comparison and they can help you set up the input parameters for the stored process the correct way.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation