I'm trying to create a temporal condition object (day) to use as an "optional prompt" in BO 6.5.
The aim is to allow the user to select a particular valorization day for its selection OR to let the prompt in blank valorizing the values for ALL the days contained in the tab.
The syntax I used for the condition object is (for example):
Tablesample.dataday = @PROMPT ('Select Day', 'D', 'Time\Day, mono, constrained) OR @PROMPT ('Select Day', 'D', 'Time\Day, mono, free) = 'ALL'
Parsing the syntax in Designer 6.5, it seems to be ok and compatible with SQL SERVER 2000 (the server in use). But when I try to test the query in BO 6.5, I can not answer ALL in the PROMT question, I can only insert a single valo day.
Can anybody help me to solve my problem?
Thank you in advance