>I am having a tough time create a little routine to rename a table in a database. I want to add a TEMP table to a database of the same structure as one of the existing. Then drop the original table and rename the TEMP table into the original.
>
>Here is what I do:
>

>cTblName = "MyTable"
>use (cTblName)
>afields(aDbfStruct)
>set database to MyDatabase
>create table TEMP name TEMP from array aDbfStruct
>close tables
>drop table (cTblName)
>rename table ("TEMP") to (cTblName)
>*-- I was hoping that rename table will rename actual file name
>*-- but it does not. So I have to do this:
>rename ("TEMP.DBF") to (cTblName + ".DBF")
>rename ("TEMP.FPT") to (cTblName + ".FPT")
>

>
>But the table MyTable.DBF is not part of the database after all of that.
>
>What am I missing?
>
>Thank you.

Dmitry,
I would use gendbc generated code edited for this kind of job. However using this code you could do it with a slight change:

>

cTblName = "MyTable"
use (m.cTblName)
afields(aDbfStruct)
set database to MyDatabase
close tables
drop table (m.cTblName)
create table (m.cTblName) from array aDbfStruct

Cetin