Rename table is not working!!!

[Anonymous]

Hi guys,

i want to change the name of four tables using this script

For vTableNo = 1 to NoOfTables()-1

let svalue='tab1';

Let vTableName = TableName($(vTableNo)) ;

Rename Table vTableNo to svalue;

next  vTableNo

but nothing happens.

swuehl

stalwar1

[swuehl · Accepted solution]

I believe RENAME TABLE should use the table name vTableName, not the number vTableNo as source table name.

Using dollar sign expansion might also be required to get the variable values.

Rename Table $(vTableName) to $(svalue);

Then I am not sure what you are trying to achieve here, do you want to rename all tables to the same name?

I don't think that can work (well, haven't tried it).

Or do you want to do something else?

[Anonymous]

And here is a sample bit of script:

For vTableNo = 0 to NoOfTables() -1

trace vTableNo: $(vTableNo) ;

let vTabNum = $(vTableNo) +1 ;

trace vTabNum: $(vTabNum) ;

let svalue='tab' &  $(vTabNum) ;

trace svalue: $(svalue) ;

Let vTableName = TableName($(vTableNo)) ;

trace vTableName: $(vTableName) ;

Rename Table $(vTableName) to $(svalue) ;

next  vTableNo

The trace command is always useful when debugging thing like this, I have whacked a few in so you can see what it is doing.

[Anonymous]

thanks very much.

it is working