Hello Ann,

>On Wed, May 8, 2013 at 10:31 AM, Olaf Kluge <

<mailto:olaf.kluge%40satron.de> olaf.kluge@...> wrote:

>>
>> I would like to assign a element-group to an table. For example group

valve

>> - table t_valve. Now I can realize this with an statement, but perhaps I
>> can
>> assign the table not by its name, rather with its table ID? Maybe I can
>> select the ID and. "select * from TABLEID where xxx"?
>>
>
>I'm not sure I understand what you're asking, but if you want to reference
>a table by it's RDB$RELATION_ID, don't do it. Those values are not
>stable across a backup/restore. SQL gave you names. Use them.

>Good luck,

>Ann

First, Thank you.

Is there a possible way to select/insert records in a table where only the
tablename is known - and without a statement? In my case the structure of
some tables is the same, only the names are different. I can assign a
tablename to an category and would like to update the corresponding table.

For example:

Members:

ID Name Category

1 Compressor1 1
2 Compressor2 1
3 Valve1 2

Categories:

ID Table

1 TCompressor
2 TValve

TCompressors:

ID STATE .
1 .

Now If the PLC send me a change of ID 1, I would like to look for the right
table and update this. Select table from . . update TABLENAME set STATE = .

How can I realize this without an statement?



Thank you!



[Non-text portions of this message have been removed]