Sample 4GL to move Char(1978) to BYTE

[dmooreora]

Can someone get me a sample of 4GL to move Char(1978) to BYTE. Currently, this is what I am doing.

In order to move data from a table with CHAR(1978) into a blob field, I'm using the load command. But, when I try to load the data into the table with the BYTE datatype field, I get the error:

32405: Incorrectly formed hexadecimal value.

Please Help!

 

[jfshadow]

In the 4GL code you will need to assign the CHAR to memory with "LOCATE l_blob IN MEMORY" for a variable like:

DEFINE l_blob text,
l_char char(1978)

SYNTAX:
LOCATE l_blob IN MEMORY
let l_blob = l_char

From here you can insert into the text field of the destination table. I don't have any of the code that I've implemented this in in front of me, so please double check the syntax. However, I believe the "LOCATE ..." is what you need.

A good C or Perl program works wonders too.