| 2/18/2015 (10 years ago) | |
| Clarify | |
| Any | |
| 2/18/2015 (10 years ago) | |
| Windows (Any) | |
| Any |
SchemaEditor: Expanding the length of a column doesn’t expand the length of corresponding view columns
Given an existing column, such as web_user.login_name which is varchar(30).
This column is used in views, including the table_web_cntlst view.
Use schemascript to expand the size of web_user.login_name
<updateColumn name="login_name" table="web_user" >
<length>100</length>
</updateColumn>
This works, but the view column sizes remain the same in the view.
You can see that using SQL:
select * from adp_sch_info where type_id in(400, 5164) and field_name = 'login_name'
-- 400 = web_user table
-- 5164 = web_cntlst view
It would be nice if SchemaEditor also adjusted the size of the corresponding view columns.
Most of the time, this is not an issue at all. It can be an issue when trying to use the Dovetail SDK to perform a query against the view using a filter where the length of the value is greater than the original size of the column.
For example:
- expand table_web_user.login_name to 100 characters.
- using the Dovetail SDK, query table_web_cntlst with a filter of login_name = ‘1234567890_1234567890_1234567890_1234567890’
There is an open enhancement request for SchemaEditor to support this functionality.
Workaround
In the meantime, the following workaround may be useful.
Update the ViewColumn, and change its description. This will force the view column to get rebuilt
<updateViewColumn name="login_name" view="web_cntlst" >
<table>web_user</table>
<column>login_name</column>
<!-- original description was: "Web User login name" We're simply adding a period to the end. -->
<description>Web User login name.</description>
</updateViewColumn>
You must be logged in to post a comment.
Login