I've got an existing report with quite a few fields on it.
I have just modified my database changing a varchar(10) to a varchar(20)
When I test it out with data '12345678901234567890' the query开发者_Go百科 against my view works perfectly fine. However, even after I've completed a "Verify Database" it doesn't display the whole value.
I have attempted using a formula to display it, it still truncates it at 10 characters, I have also done a LEN({myfield}) and it displays 10.
I have also used the command "Update datasource location".
Somehow that field length information is stuck.
I have resolved it in a roundabout way.
- I removed this field from my datasource,
- I then verified the database and the field was removed from the report
- I then re-added the field to the datasource
- Then re-added the field to the report
Everything displayed properly.
精彩评论