Views - MSSQL (Magic xpa 4.x)

A View must have a virtual unique index defined. Insert, Update, and Delete operations are permitted on Views. MSSQL allows updates on multiple table views. If one of the segments of the Position Index is updated, records shown on the screen may become inconsistent.

Magic xpa considers a View as a regular table. Magic xpa should not be used to perform any rename or convert operations. If Magic xpa is used to execute any rename or convert operations, Magic xpa will display an error message and will not convert/ rename the View in the database.