Icon View Incident Report

Serious Serious
Reported By: Chris Clark
Reported On: 3/22/2013
For: Version 2.12 Build 2
# 3819 Changes to Tables Referenced In Views Not Being Reflected Properly

Would it be possible to get clarification on when views need to be 'updated'.

While Developing an Application I've occasionally run in to a couple of issues when changing DB table structure which is referenced in views.

If I have a view with a Select * in it, Adding Fields to the Table its derived from sometimes causes incorrect fields to be returned to the application, and sometimes when changing data types in the source tables, the previous types are still represented.

Altering the view and saving it seems to sort this out, and I'm assuming its something to do with the view being prepared once prior to use, but when I deploy I'm just wondering if I need to drop and re-create all views if the source tables are changed.

Comments Comments
Deleting columns from a table could cause an AV when a view referencing the table was opened.

Resolution Resolution
Fixed Problem on 3/24/2013 in version 2.13 build 1

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial