[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Add table to select paragraph



Hello Gurus!

        Is there a way to add a 'dynamic' table name in a SELECT paragraph?
For example, in the following code, I would like to include a table called
'tab_x' in the selection, only when it is called for ($include_tab_x = 'Y').
        The code below doesn't work:

Begin-Program
  Do Init
  Do Test
End-Program

Begin Procedure Init
  move '' to $extra_tab
  move '' to $and_clause
  if upper($include_tab_x) = 'Y'
  end-if
End-Procedure