Skip to Content
author's profile photo Former Member
Former Member

Freehand SQL @Prompt/Calendar button/Date format

I have difficulties locating information on these topics. Most of our DeskI reports are freehand-sql reports. The queries contain @prompt functions.

First question is: where can I find the documentation on @PROMPT? What are the parameters?

When ran in Infoview date prompts are sometimes followed by a button that displays a calendar control to select the date, sometimes not.

Second question: what determines when the button is used?

Sometimes if someone modifies a report and exports it again the date format in the Infoview prompt changes, in particular if the button is used. For instance there was a report prompting for a start date and an end date. Both dates were returned in European format (day/month/year) and apparently the start date was followed by time 00:00:00 and the end date by 23:59:59. Now, after someone exported the report again with a non-related change to the query, the dates are in American format (month/day/year) and are both followed by time 12:00:00

Third question: what determines the date format returned by the calendar control? (More importantly, how do I control the format)

This is driving me mad as users are asking me to put it back as it was last week and I can't find anything about any of this. I asked questions by raising a ticket several months ago and was taken to a wild goose chase involving several Webex sessions with an support engineer changing the locale of my machine to Fidji (or something) telling me that this was the place that had the date format I wanted. Nice one. Of course it was not. It happened the current month in that locale was like in English but the following month was not...

Thanks in advance for any help.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2008 at 05:35 PM


    First question is: where can I find the documentation on @PROMPT? What are the parameters?

    The best place to learn about @prompts is in the DM310 (Universe Design) course. Here is a quick rundown based on BO XI R2 SP3 behavior:

    Consists of seven parameters, separated by comma:

    prompt (the message to the user)

    data type (A (alpha), N (numeric), or D (date))

    LOV Pointer or hard-coded list (LOV can be a pointer to a class/object in your universe or a delimited hard-coded list enclosed in curly-brackets { })

    Mono or Multi (equivalent to saying whether the comparison is based on equals (=) or in a list (in))

    Free or Constrained (free allows the user to type free-hand or pick from a list, constrained makes the user pick from a list only)

    Not_Persistent (optional and when used does not re-present the last chosen values from a previous run in the current run, otherwise when skipped will "cache" the last response as pre-selected)

    User:0 (or User:1, etc, used to create a set sequence when this prompt is used with other prompts)

    so, here is a sample:

    @prompt('Select Widget','A','Widget Group\Type',mono,constrained,Not_Persistent,,User:0)



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks for your replies. The numbers below correspond you the numbering of your questions/suggestions

      1) Regional Settings on the server show the date in the British format (dd/mm/yyyy for the short date)

      2) Force Migration is checked on my client and English UK is selected

      3) Looking for the 'corresponding .prm file', but I have no idea what it is...

      4) Infoview on the server has already the default interface locale set to English (United Kingdom). How is that supposed to make any difference to the running of Infoview on clients?

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 03:01 PM


    The .prm file can be found on the server your CMS is installed. For example our environment sits atop a SQL Server ODBC Connection.

    Therefore our .prm file is located in

    C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\odbc\sqlsrv.prm

    Within the connectionserver folder, you can find various database subfolders, each of which has its own .prm file.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.