>I need a view based on the user which is currently logged in my app. I have set a global variable containing this user's ID.
>
>Can I use the content of this global variable as in:
>Select * ;
> from MyTable ;
> where MyTbale.User_Id = MyGlobalVariable'sContent
>
>What would be the correct syntax for the where portion of the statement so that I could extract the content of the variable ?
>
>TIA
>
>Pierre Richard

Precede the parameter with a question mark:

where MyTbale.User_Id = ?MyGlobalVariable'sContent