SQLDB ibconnection needs mentioning that COMPUTED BY fields are not seen as read-only
Original Reporter info from Mantis: BigChimp
-
Reporter name: Reinier Olislagers
Original Reporter info from Mantis: BigChimp
- Reporter name: Reinier Olislagers
Description:
Suggestion for text - probably to go in the main Tibconnection doc as IIRC there is no separate space for sqlquery as used by ibconnection
If you have COMPUTED BY fields (server-side calculated fields) in your Firebird table, SQLDB will not pick up that these are read only fields (for performance reasons).
In this case, auto-generated INSERTSQL,UPDATESQL statements can lead to error messages like "attempted update of read-only column". The solution is to manually specify that the field in question may not be updated after setting the TSQLQuery's SQL property, e.g.:
sqlquery1.fieldbyname('full_name').ProviderFlags:=[];
Mantis conversion info:
- Mantis ID: 25545
- OS: Windows
- OS Build: Windows 7
- Platform: x64 (with x86 compiler)
- Version: 2.7.1
- Fixed in version: 3.0.0
- Fixed in revision: 1063 (#af317c40)
- Target version: 3.0.0