General information
Category:
Coding, syntax & commands
>John, I'm not David :-) but if you keep in mind these are MY opinions....
And your opinions are valued here...
>
>PK is Primary Key and FK is Foreign Key. To be REALLY basic (for any newbie reading this) the Primary Key is the unique identifier for each record. A Foreign Key is the COPY of this key that links one table with another. A Child table will have its own PK, plus FK values from the Parent Table. There can be many identical FKs in a table.
As soon as I read "Primary Key" I knew what he meant... but sometimes it is not as clear right now as it might be in the future...
>
>As for creating p-views, if they are updateable, the view goes into the DBC and is called like a table with 'USE MyView' in a form. If you haven't set the parameter(s) VFP will ask you for them (not a good idea from the user point of view).
For updateable views... will they update the table if send sql update is checked? If so I must be doing something wrong as when I run the form it will update the view ok but not the table that the view is based on??? Did I miss something???
Do you add the view to the dataenvironment? or do you do a use in the load of the form?
Thanks
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only