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

Query selection criteria - changing description field..?

Hi Experts,

i want to change description filed in user query selection criteria form..

i have 3 fileds :

docdate - this filed i want to chage 'Document First'

docdate - This filed i want to change 'Document Last'

name -

my problem: screenshot

[Click Here|http://img638.imageshack.us/img638/3466/userqueris.jpg]

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Sep 23, 2010 at 10:05 AM

    The system always asks with the description of the field you refer to with the parameter variable in the select statement.

    I sometimes defined a UDT only for getting the appropriate title in the parameter entering window. The table has no data; I used it only for its field names.

    (The parameter request can be placed inside a comment and the entered value is used setting an SQL variable like this:

    declare @d datetime
    /*select t.createdate from ordr t where t.createdate=[%0]*/
    set @d=[%0]

    This SQL variable can be used later in the real query.)

    (But then you loose the possibility to choose from the u2018List of existing valuesu2019

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2010 at 06:42 PM

    have you tried use something like this ...: select Field as "name you want" ... from OWOR

    Maybe using an alias for every field can solve this ...

    Well let us now if this help to you.

    regards,

    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.