>I have a project that requires a one to many relationship on a relatively large sscale. There are about 1/4 million "many" records and about half that many "one" records. I thought it would be good to use a local view with that relationship and all of the fields (including the keys) specified for update, for "send updates" to be checked. I think I need the keys specified because I will have to add records. In my load event I open the view with the nodata setting. Then when the user fills in one of the search fields, I create the view again with an SQL clause which is constructed from the value in the search field.
Be aware that recreating the view like this deletes and recreates many records in the dbc, and can eventually lead to dbc bloat. As long as you are planning for the periodic maintenance that this strategy requires (PACK), you'll be alright.
>I also respecify with dbsetprop the tables in the view, the key fields in the view, and that it should send updates. However in my testing, I can't seem to get the updates to persist even though I use "if tableupdate". Then when I go back to the view designer all of the update properties have been set to nothing. Any ideas?
Not sure what's going on here, but try opening the view with EView after you have modified it to see what changes have stuck. You can also use EView to automatically generate the code required to successfully recreate the view with all its properties.
Erik Moore
Clientelligence