Prompt Boxes

[stewartsetter]

Hi,

I have written a query to extract data from MFG TR:HIST table, as this is to be used by other people, I have written in prompt boxes into the query, the date from and to boxes work but I can't seem to get the Item Number box to work. Can anyone advise where I am going wrong ?

Thanks,
Stewart

The script is :

viewpoint native;

define
string Item_Number = parameter/cls prompt "Enter Item Number"
date Date_from = parameter/cls prompt "Enter date from" default
todaysdate ;
date Date_to = parameter/cls prompt "Enter date to" ;


where
Uppercase(tr_Hist:item_number) = Uppercase(Item_Number) and
tr_hist:date >= Date_from and date <= Date_to

list/pagewidth=999/pagelength=0/xls/domain="tr_hist"
tr_hist:trans_type
tr_hist:trans
tr_hist:date
tr_hist:effective
tr_hist:item_number
tr_hist:loc
tr_hist:remarks
tr_histrder
tr_hist:user_id
tr_hist:tr_serial
tr_hist:qty_change/mask="zzz,zzz,zz9.9"