I agree that this situation is quite confusing. But I don't know any solution.
>The thing that do me more to anger,
>it is that the example of the documentation takes to me in turn.
>
>Doc example:
>
>... RENAME TABLE is used to change the name of the table from table1 to table2.
>CLOSE DATABASES
>CREATE DATABASE mydbc1
>CREATE DATABASE mydbc2
>SET DATABASE TO mydbc1
>CREATE TABLE table1 (cField1 C(10), n N(10))
>CLOSE TABLES
>REMOVE TABLE table1
>SET DATABASE TO mydbc2
>ADD TABLE table1
>RENAME TABLE table1 TO table2
>
>
>Apply the RENAME TABLE on mydbc1:
>
>CLOSE DATABASES
>CREATE DATABASE mydbc1
>CREATE DATABASE mydbc2
>SET DATABASE TO mydbc1
>CREATE TABLE table1 (cField1 C(10), n N(10))
>CLOSE TABLES
>RENAME TABLE table1 TO table2
>REMOVE TABLE table2
>SET DATABASE TO mydbc2
>* with this the program fail
>ADD TABLE table2
>* with this the program is ok but you cannot write
>... RENAME TABLE is used to change the name of the table from table1 to table2.
>ADD TABLE table1
>
>
>Fabio
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
