Using a long raw field

[rcoyle]

I am using D6 with DOA 3.4.5 with Oracle 8I. I have a field that is defined as longraw. I am using a ToracleDataset to connect to the table. When the field is displayed on the screen ising a dbmemo only the first character appears. Should I use a long raw field or another type? Has anyone else seen

 

[Marco Kalter]

A dbmemo expects character data. A long raw may contain non-character data such as zeroes. This can explain the truncated text in the memo.

 

[rcoyle]

I verified that the data was there via a MS Access query and all appeared. When using the DOA components only the first character appeared. It is the correct first character, but only the first character.

rcoyle

 

[Marco Kalter]

Can you upgrade to the current 3.4.6 and try again?

 

[rcoyle]

I don't think that my license covers an upgrade at this point.

 

[rcoyle]

Where can I find a URL to 3.4.6? All I find is 4.0 for D6.

 

[rcoyle]

I did download the file as you indicated. Only the 1st character shows again. Perhaps these components will not show a long raw field. Anyway, I have to move on as i have wasted 3 days here and gotten no where.

 

[rcoyle]

I did some further investigating on this matter and as it turns out the DOA components were ok. The problem appears to occur when loading the blob field from another source. As a temporary fix I used the DOA components and looped through a TOracleDataset copying a varchar field to the blob field and posting each row. Everything shows up as expected. Now I will have to figure how to copy this data from a varchar field to a blob field using a pure SQL statement in Oracle.