>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, then 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 appreciated.
>
>Thanks,
>Laura
Q1 : Why you are bypassing the the view incase of adding a record?. You can treat the view as a table.
Q2 : This will work when these tables become remote, but every SQL INSERT command you used you will have to replace with SQLEXEC("HANDLE","INSERT INTO ....","TABLENAME")