Unable to insert characters into list of byte varing field
Thurston, Alan JTST:EX
Alan.Thurston at gov.bc.ca
Mon Jun 20 13:25:14 CDT 2016
I have a screen that includes a list of byte varying field (CBR_DESC_COMMENT) that should allow full edits of the field. I can delete characters by using Backspace and I can over-write characters by toggling the cursor to over-write mode. However, I can't insert characters either in the middle of the field or at the end of the field.
The screen definition is:
SCREEN CBR_DESC
FILE CBR_DESC IN LRBDB
FIELD CBR_DESC_ID OF CBR_DESC REQUIRED NOCHANGE &
NULL VALUE NOT ALLOWED
FIELD CBR_ID OF CBR_DESC ID SAME REQUIRED NOCHANGE &
NULL VALUE NOT ALLOWED LOOKUP NOTON CBR_DESC VIA CBR_ID , &
CBR_DESC_ID USING CBR_ID OF CBR_DESC , CBR_DESC_ID OF CBR_DESC
FIELD CBR_DESC_COMMENT OF CBR_DESC CHARACTER FOR 1,18 &
NULL VALUE NOT ALLOWED popup from 11,1 to 23,80 on data
FIELD DESC_START_DTE OF CBR_DESC NULL VALUE NOT ALLOWED
FIELD DESC_END_DTE OF CBR_DESC NULL VALUE NOT ALLOWED
FIELD DESC_STATUS OF CBR_DESC NULL VALUE NOT ALLOWED
FIELD MODF_BY_CASE OF CBR_DESC REQUIRED NOCHANGE &
NULL VALUE NOT ALLOWED
FIELD UPD_BY OF CBR_DESC NULL VALUE NOT ALLOWED
FIELD UPD_DTE OF CBR_DESC NULL VALUE NOT ALLOWED
In the database the table is defined as:
SQL> show table cbr_desc
Information for table CBR_DESC
Columns for table CBR_DESC:
Column Name Data Type Domain
----------- --------- ------
CBR_DESC_ID INTEGER
CBR_ID INTEGER
CBR_DESC_COMMENT LIST OF BYTE VARYING
Subtype: TEXT
Segment Length: 2000
DESC_START_DTE DATE VMS
DESC_END_DTE DATE VMS
DESC_STATUS CHAR(3)
MODF_BY_CASE INTEGER
UPD_BY CHAR(8)
UPD_DTE DATE VMS
Any ideas why the CBR_DESC_COMMENT field would prevent insertion of characters?
Thanks!
Alan Thurston (Independent Contractor)
Working for the Ministry of Jobs, Tourism and Skills Training, and Responsible for Labour
250-387-0220
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20160620/a411f5ee/attachment.htm>
More information about the powerh-l
mailing list