>>Hi everyone
>>
>>How can I "programatically" create a relation between to or more tables in a dbc ?..
>>Thanks in advance.
>>
>>Carlos Burgos
>
>I don't know of a way to do it, but I do all changes to table structures as follows:
>
Have an empty copy of the database (zero records in all tables). This is the "official structure", where all changes are done first.
>Have a programm that combines this empty with the client data, doing an APPEND FROM for each table.
>
>Some temporary directories are required. Also, RI must be disabled - or else, make sure you copy a parent table before you copy the child table.
>
>Once you have the generic program, any changes - fields, new tables, indices, views, relations, you name it! - are done quite easily.
Himar, am I missing something here? Isn't this just a case of the Set Relation command?
GENDBC prog, run on a databse with relationships already set up, produces a program from which you can look at the code necessary to progtrammatically set up relns. etc.
Or, again, am I missing something in the question?
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.