General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I want to copy the data from a table say "BATCH_TEST" to another table whose name I donot know and the name can be picked from the Variable. I tried like this
mvar_name = "Table_name" where Table_Name is the table name I want to use.
To copy the structure of already existring table, I can do like
Use BATCH_TEST
copy structure to substr(mvar_name,1)
and the new table is created by the name table_name.dbf. Now I want to transfer the data also by using the variable name instead of table name
say
insert into substr(mvar_name, 1)(x,y,z)values(BATCH_TEST.x....
this gives me syntax error. Is there any other way to do so.
Thanks
Bharat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only