Information générale
Titre:
Updating Remote Tables
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement