Jump to content
  • 0
telepet

Does View update itself if source Table design is changed?

Question

I've created a View that utilizes several tables.  When I update the design of a Table, I'm not seeing that change reflected in my View.  Is this normal behavior, or perhaps I'm overlooking something? 

As a work-around, I can delete the view, and create another, using the same tables (which by this point have the mentioned Design change already in place), and everything just works.  I'd love to find quicker way to go about this though.

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

I have found that if you add a new field to a table, and you have a view associated with the table the field added to the table shows in the view without the “Include field in View” box checked.
If you go into the view and navigate to “Field Properties”, you will find your newly added field at the bottom of the list, select it, then check the “Include field in View” check box under field options.

Share this post


Link to post
Share on other sites
  • 0
2 minutes ago, JEllington said:

I have found that if you add a new field to a table, and you have a view associated with the table the field added to the table shows in the view without the “Include field in View” box checked.

1

Brilliant!  This seems to be working.  You saved me a ton of time-- thanks!

Share this post


Link to post
Share on other sites
  • 0

Each time you open a view or call a view via DataPage, view is making a call to table to filter the data. Therefore the data is being generated on each call so data is updated. But as for the design as it is mentioned above newly added fields should be available in the wizard but they need to be included (by default they are not included in view).

You also have the option to change the name of the fields in the view to make them shorter. By default you have TableName_FieldName if you change table name part and leave "_" by moving to next field system will ask you if you want to have the same naming for other fields as well to change them all at once

Share this post


Link to post
Share on other sites
  • 0
2 minutes ago, MayMusic said:

By default you have TableName_FieldName if you change table name part and leave "_" by moving to next field system will ask you if you want to have the same naming for other fields as well to change them all at once

 

Cool-- I didn't know about this trick.  Thanks!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...