Skip to Content
avatar image
Former Member

data foundation @prompt

Hi all,

I created a derived table in data foundation and put a @prompt in where clause for user to input.

if i type:

@Prompt('ID: ','N') - > it's OK

if i type:

@Prompt('ID: ','N','DB\Daypart\ID', mono, constrained)-> There's an error "Invalid Prompt definition.  (IES 00005)"

Please help me!

Thanks,

Danh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 22, 2014 at 04:40 PM

    Classes and Objects are created in the Business Layer. Derived Tables are created in the Data Foundation layer which is below the Business Layer. Hence, the Classes and Objects that you create in the Business Layer are not available in the Data Foundation layer. 

    Try the below and it will work fine.

    @Prompt('ID: ','N','', mono, constrained)

    Add comment
    10|10000 characters needed characters exceeded