| Author |
How can I open a table named as the result of an expression
|
|
| Juan Carlos Reguera 2006-10-25, 7:34 am |
| How can I open a table named as the result of an expression? . (ej. table="DE"+"TABLE"+"01")
| |
| Roland Wingerter 2006-10-25, 7:34 am |
| Juan Carlos Reguera wrote
> How can I open a table named as the result of an expression? . (ej.
> table="DE"+"TABLE"+"01")
-------
mytable="DE"+"TABLE"+"01"
use (mytable)
or
select * from &mytable
or
q1 = new query()
q1.sql := [select * from ] + mytable
q1.active := true
Roland
| |
| Juan Carlos Reguera 2006-10-25, 7:34 am |
| Very, very simple. But you have resolved an important blocking trouble in my job about working with tables with sequences of names.
THANK YOU VERY MUCH.
Roland Wingerter Wrote:
> Juan Carlos Reguera wrote
> -------
> mytable="DE"+"TABLE"+"01"
>
> use (mytable)
>
> or
>
> select * from &mytable
>
> or
>
> q1 = new query()
> q1.sql := [select * from ] + mytable
> q1.active := true
>
> Roland
>
>
| |
| Roland Wingerter 2006-10-25, 7:34 am |
| Juan Carlos Reguera wrote
>
> THANK YOU VERY MUCH.
------
Glad to help.
Roland
|
|
|
|