This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From11/07/1997 16:34:11
Beatty Laura #008622
The Missing Piece
San Francisco, California, United States
To  
All


This may seem like an obvious question, but since I cannot find any documentation related to this, I thought I'd put it out there and see if I'm on the right track.
I've got several Local Views which I am using as prototypes until my client can fork over the dough to upgrade to a real server. Anyhow, I have paramterized all of these views and am allowing updates. A primary key (or keys) have been identified for each view. In order to add records to the base table I am bypassing the view and issuing a direct SQL insert into the table. (IF I simply add records to the view, the SQL update doesn't populate the key fields for me.)
Question #1: Is there a better way to do this?
Question #2: Will this work when these tables become remote?

Any and all advice would be much appreciated.

Laura