Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    UK
    Posts
    9

    Unanswered: Ingres Report Writer

    Hi,

    I was wondering if anyone could help me...

    In Ingres Report Writer, how do you prompt a user for an input value, but default to something should they enter blank? In particular, I want to prompt for a date, but default to today's date if blank...

    I've tried the following in the .DECLARE section:

    indate = date with prompt "Enter date (leave blank for today's date):" with value current_date

    which doesn't seem to work.

    Incidentally, is it possible to not allow a user to enter a blank input?

    Any help would be appreciated. Thanks.

  2. #2
    Join Date
    Nov 2003
    Location
    UK
    Posts
    2
    Hi,

    You appear to have correct syntax, try changing current_date to date('today').

    Or, in your header section or where-ever else you print the first data, do

    .if indata = '' .then
    .let indata = current_date
    .endif

    I do not think you can force the user to actually enter something when prompted by report writer, life would be too easy if we could control users!

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •