`

view view_name has errors 原因

 
阅读更多
刚才遇到这样一个问题。
我们系统有部分表是通过视图允许别的系统访问的,由于昨天我删除了两个表里的部分字段,导致了其他系统访问时报view view_name has errors,仔细分析了一下,原因是:我删除的这两个字段是包含在提供给别的系统的视图里,这样,基表里已经没有了该字段,而视图在查找时当然找不到该字段了,所以就报errors
所以我就把这两个试图删掉重新创建了,没想到我有犯了一个错误,由于这些视图访问是要有权限的,我这样删了,再重新建了一个名字相同的视图,结果其他系统根本就无权限访问这两个视图, ,还要重新分配权限。。。
其实上述问题可以不用删了重建,后来想了一下,直接将自己删掉的那几个字段在视图里赋值为空不就解决了。
分享到:
评论

相关推荐

    DevExpress VCL 2012 vol 1.6源码、例子、帮助-Part2

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    play-java-forms-example.zip_java_play

    if (filledForm.hasErrors()) { return BAD_REQUEST; // 返回错误页面 } UserForm user = filledForm.get(); // 验证成功,获取用户数据 // ... 进行其他业务逻辑 return OK; // 返回成功页面 } ``` 五、显示...

    WFP MVVM 验证数据demo

    它包含多个事件和方法,如`HasErrors`属性、`GetErrors`方法以及`ErrorsChanged`事件。 **2. 视图模型的验证实现** 在MVVM中,ViewModel通常包含业务逻辑和验证规则。你可以直接在ViewModel中定义验证方法,或者...

    利用 Oracle 和 PHP 管理分布式跟踪文件

    / grant necessary database privileges to tfmadmin tfmAdmin_privs_and_syns.sql grant necessary java privileges to tfmadmin tfmAdmin_java_privs.sql if this fails with any spurious dbms_java errors then...

    DevExpress VCL v2012 vol 1.6源码、例子、帮助

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    DevExpress VCL v2012 vol 1.6源码、例子、帮助-Part1

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    DevExpress VCL v2012 vol 1.6源码、例子、帮助-part2

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    DevExpress VCL 2012 vol 1.6源码、例子、帮助-Part1

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    DevExpress VCL v2012 vol 1.6源码-例子-帮助-part2

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    DevExpress VCL v2012 vol 1.6源码-例子-帮助-part1

    Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-...

    freemarker总结

    sort_by(name) 表示所有的user按user.name进行排序 hashes内置方法 hash?keys 返回hash里的所有keys, 返回结果类型sequence hash?values 返回hash里的所有value, 返回结果类型sequence 模板 使用FTL(freeMarker...

    google api php client

    However, as each property of the JSON API has a corresponding generated class, the above code could also be written like this: ```php // create the datastore service class $datastore = new Google_...

    struts上传

    Struts 2 提供了内置的错误处理机制,如 `hasErrors()` 和 `getErrorCode()` 方法,可以用来检查和显示上传过程中可能出现的问题,如文件类型不匹配、文件过大等。 7. **展示结果** 根据Action配置的结果视图,...

    springmvc 使用hibernate-validator校验包

    如果存在错误,可以通过`BindingResult.hasErrors()`判断,并通过`BindingResult.getFieldError()`获取具体错误信息: ```java @PostMapping("/register") public String register(@Valid User user, BindingResult...

    structs编程设计

    if (hasErrors()) { return INPUT; // 如果有错误,返回INPUT表示重新显示表单 } // 正确处理表单数据,如保存到数据库等 // ... return SUCCESS; // 表单处理成功,显示SurveyResult.jsp } @Override ...

    EurekaLog_7.5.0.0_Enterprise

    8)....Added: Exception line highlighting in disassember view in EurekaLog exception dialog and Viewer 9)....Added: Detection/logging Delphi objects in disassembly view 10)..Added: Support for multi-...

    CE中文版-启点CE过NP中文.exe

    The graphical memory view now has a lot more options to set it just the way you need Codepage support in hexview structure data from PDB files can now be used, and are stored in a database for lookup ...

    FlexGraphics_V_1.79_D4-XE10.2_Downloadly.ir

    Added TFlexFileFormat.StreamSupport property (default True), which difines, is it necessary to open file stream or give the file name only. - FIX: If the TCustomProp.Assign method calls when the ...

    RealThinClientSDK_v610_BETA

    To add the RTC SDK paths to FPC, you will need to modify the file "xcode/<ProjectName>.xcodeproj/project.pbxproj". The path to the RTC SDK 揕ib?folder needs to be added as two new ?Fu?parameters. ...

    Senfore_DragDrop_v4.1

    * The name and exact version of your operating system (e.g. NT4 SP5). * The exact version of the Internet Explorer installed on your system. If you can provide me with a minimal application which ...

Global site tag (gtag.js) - Google Analytics