prompt in tablename

[Former Member]

Hi,

is it possible to create a derived table within a @prompt in tablename?

I have many tables with the same structure. The SQL of the reports are equal except for the owner of the tables.

I hope you have an answer

Best regards in forward

Michael

[Former Member · Accepted solution]

Hi,

This is supported in a Derived Table. But you have to pay attention that you have to set the datatype to numeric to avoid quotes generation enclosing table name.

Here is a sample based on the Club database that returns the column data from a table.

The column name and the table name are equal.

Select @Prompt('Table?','N',{'Country','Region','City'},mono,constrained) as label from @Prompt('Table?','N',{'Country','Region','City'},mono,constrained)

Hope this helps

Regards;

Didier

[Former Member · Accepted solution]

wonderful!

That´s it!!!!

Best regards

Michael

[Former Member]

Yes it is possible prompt on derived table.......

Eg: A_DRV.sysdate=@Prompt('Enter Date','D','sysdate',,,,)

[Former Member]

Yes it is possible prompt on derived table.......

Eg: A_DRV.sysdate>=@Prompt('Enter Date','D','sysdate',,,,)