Query "insert into.... select from ...."

Hi all,

I try to run query "insert into... select from ...." on HF/CS but it doesn't work, any body know if this query systax can be execute on Hyperfile or what query can do similarly?

Best Regards,

camsinh

I think complicate queries are not alowed on HF
HF is not a SQL based DB, and (in my opinion) not a real database at all.

You should make a Hread() - HAdd() loop I guess.
Or make an Insert-One-Row loop with the result of a select query.
(wich is very slow if there are lots of rows...)
Sorry, that's one of the reasons I chose not to use HF anymore.