philipp crocoll

Hallo,
I want to remove some records from a Table A (which can be ANY table of my
database) to a Table B in rivate:-alias, but Table B does not yet exists.
This means, I have to create a table with the same structure. I also need to
have the key field(s) in the new table, but Table B should not have
look-up-tables anymore. (Because this makes problems as B is in another
alias than A).

What's the best way to do this? The only way I see is to use a create-sql
(but i do not know how to find out the key fields in a table). Shouldn't
there be an easier way?

Thanks,
Philipp

ed nash

Phillip,

Look at ObjectPAL help for enumFieldStructure and the example code.

carolyn wendover

If you run a delete query you will end up with a table called Deleted in
your private directory with the same field structure as the original and
containing the records you deleted. Rename this to the table you want and
re-add the indexes. If you do not rename the table, it will be
automatically deleted by Paradox when you end the session.

HTH,
Carolyn

michael israel

Table, Create, Borrow (from table A), Check files that you want included
(e.g. secondary indices, val, lookup).
Easy.