>Hello,
>
>I want to send a program(CREATE SQL VIEW "DRAWREL_DRAWINGS_VIEW") to a project where they have the database and the dataset of tables which they are running since six yrs.
>
>If there were any changes i used to create the new exe for them.
>
>But now i want to create a new view for them at there project.
>
>Because we dont have the install shield here so what is the best way for me to create a program or some thing so they can run that at there site and it should automatically create the view in there pmis.dbc(database).
I handle the client-site update as follows.
Do all changes in the database - whether adding fields or views, or defining RI - in a copy of the database with zero records for each table.
Do an APPEND FROM for each table. Some details, like copying data to temp folders, I will leave as an exercise to the reader.
If you have a parent-child relationship, you may get "trigger failed" if you copy the child first. This can be solved in two ways:
1) Use adbobjects() to get information about the relations. Copy the parent first.
2) Use TaxRI for your RI (from the UT downloads), and disable RI temporarily for each file you copy. This is easier, and the APPEND FROM is at least 10 times faster, since no RI needs to be checked.
I currently use option 2.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)