Copy multiple records to another file, question.

[thorgil]

Hi everyone!

I want to copy (in a script) all records (0 - many) from a database (called main) where a specific field ("id") matches a number (say 7) to a different database (called temp).

The temp database is empty but with fields defined.

How?

Is there another way than doin it record by record?

/Tobias

[danjacoby]

There's a simpler way -- perform a find in the original file, then import the records into the new file. It'll only import the found set.

[veganboyjosh]

obviously (or maybe not, cos it took me a while to figure this out) you have to import the found set _into_ the new/empty/destination database, which is easily done with external scripting...as opposed to _exporting_ the records _from_ the first database. it'll just create a new database with only the fields you export. i know there is one, but i can't see the usefulness of this (export)feature.

[thorgil]

Thanks...

Helped a lot

/T