Skip to Content
0
Former Member
Jun 02, 2009 at 12:38 PM

Temporal Condition Object

19 Views

Hi,

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

Riccardo