Vfp validating data in different table
Views have other, different advantages over SPT queries, as we will discuss later on in these notes.
We ended up having a mixture of updateable and non-updateable views, both single record slices and vertical lists, and SPT queries.
If I were to work on a another, similar development project today, I would recommend using the DE.
So, in the example application below, we will be using the DE rather than programmatically opening the views in the load.
(See Figure 1.) But in practice, as development got under way, we discovered that the number of views required was going to be many more than two per table in most cases.
It’s hard to judge at this time what level of knowledge my audience has, so rather than ignore those of you who may not have encountered views or are new to SQL Server, I have included a quick run through the basics in Appendix A.