>You want to "draw the relations" programmatically, right?
Something like that. I don't really want to see the graphics, just that they are set and when I open the dbc again the lines are there.
>I don't know how to do this.
That's okay, even I don't know it <g>.
>I think the DDL (1) can set a relation between a PK and a FK, and this might draw the lines. But this will leave all the triggers at "ignore".
Okay I will run VFP-RI finding all the ignore lines is easy.
>Perhaps you can play with the DBC as a table, but this should be done with great care, lest you damage your database. (Especially, do a backup first).
Agreed.
>Also, perhaps what you really want to do is reflect the changes you did on your machine, at the client site. In this case, the easiest solution, since it encompasses many things, is to have an empty copy of the new structure, and do an APPEND FROM for each table. Copy parent tables before child tables; see ADBOBJECTS("RELATION").
For the clients machine I send a GenDBCed prg everytime and have a logic to recreate the jing bang in a temp dir and append blank from original dbf and then copy the whole thing onto the originals, this is done just once after a reinstall.
>Or, use an alternate RI-tool, like TaxRI, that allows you to temporarily disable RI.
Any link, google went crazy with the word taxri asking if I was looking for a taxi <g>
>(1) Data Definition Language. In this case, see ALTER TABLE... REFERENCES.
Will do