Unable to insert characters into blob field on Powerhouse screen

[olav Kappert]

I am not exactly sure, but I think the issue is that the blob may be 
space padded.  So you may need to delete a few characters before you 
insert them

Olav.

Thurston, Alan JTST:EX wrote:

>  
>
> I have a screen that includes a BLOB 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
>
>  
>
>------------------------------------------------------------------------
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20160812/047aab79/attachment.htm>