>>Hi, Michelle
>>I have the same question a while ago. It turns out (if I understood it clearly) that if you want to add records to your files, work directly with them, do not use views. I have tried to add records to 3 files using 1 view - doesn't work. So, I have switched to work directly with tables. But what about all this buzz about better buffering and "By-by gather/scatter"? Even working directly with tables your are able to issue tablerevert...
>>Best regards
>
>I'm beginning to see that there's no consesus on using views. My instructor said not to use updatable views at all. Then I get a bunch of people saying I should use them. Now you're saying to go back to working straight with the tables. This is getting confusing...
>
>I'm leaning towards just using the tables, myself. It's simpler.
>
I guess it's a little like the bumblebee. Supposedly, the physiology of a bumblebee is such that logically, it cannot fly. Since nobody told the bee, it doesn't know this so it flys anyway.
With me, it's views. I use views exclusively, and since nobody told me that updating more than one table from a view is a problem, I've been doing it without a hitch for as long as I've been using them.
I have a horrible fear though, that now that I know, they are all going to stop working tomorrow. I hold you all responsible if that happens.
Alan
Précédent
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