>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
Q1 : Why you are bypassing the the view incase of adding a record?
You can treat the view as a table.
Did you mark the key field as updatable?
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")