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