General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Sn,
What you describle should work (select * from abc into table qqq DATABASE MyDatabase).
It sounds like somewhere you have a leftover qqq file messing things up, perhaps in another directory. Also, you can USE the DBC file and remove all references to the table. This will allow you to start over. (Please make a backup first!)
>i have amongst others, a table abc in my database xyz. i wish to make a copy of the table abc by:-
>
>set exclusive on
>select * from abc into table qqq
>
>but i get an error message "File qqq already exists as part of a database". table qqq does not exist in the first place.
>
>i also tried:-
>
>set data to xyz
>remove table abc
>
>before i execute the select * command but i have the same result.
>how do i accomplish my mission? ta
Previous
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