How to select from a table as variable??

Applications Grid / Reports
#1

Hello, I need a grid app that allow me to pass a global variable in table name, cause the table to open depends on the type of user

I mean, I need something like that Select * from [table_name] where …

How can I do that? I’m using scrptcase v6.

Thanks in advance.

#2

IMHO you can’t … The SC grid is based on one table (or more with join etc.), but you must specific this at design time.