Read LONG in Oracle

Databases
1

Good afternoon colleagues forum.
Again I turn to ustede to help me with a problem I have.
I explain:
I have a database in Oracle LONG field, that field contains long text and I want to display on a TEXTAREA. Everything seems perfect until now. The problem happens when it should display the text in the TEXTAREA.
Just do not, because I call it like stringValue … Here my code …

[code] dim xidenti as string
dim Proceso_Parametro as String
dim MicroPro_Parametro as String

xidenti = Trim(TxtIdenti.Text)
Proceso_Parametro= Trim(PopProceso.Text)
MicroPro_Parametro= Trim(PopSubProceso.Text)

//msgbox “-” + xidenti + “-” + Proceso_Parametro + “-” +MicroPro_Parametro

SQLDATA = “SELECT descri_parametro FROM cal_parametros WHERE identi_parametro = '” + xidenti + “’ AND nomproceso = '” + Proceso_Parametro + “’ AND nomsubproceso = '” + MicroPro_Parametro + “’”

CONECTAR=XE.SQLSelect(SQLDATA)

IF CONECTAR <> NIL THEN
WHILE NOT CONECTAR.EOF
TextArea1.Text=CONECTAR.field(“descri_parametro”).StringValue
//TextArea1.Text = “prueba001”
CONECTAR.MoveNext
WEND
ELSE
MsgBox “No datos”
END IF
CONECTAR.Close[/code]

How to read the data in the Oracle LONG field?

Tnks

2

You replace the contents of the textarea on each record. If the last record had a blank field, the result will be blank. Try using TextArea1.AppendText instead.

3

Thank you!
APENDTEXT just replace, but I mark the following error.
This item does not exist

4

I think the problem is not the TEXTAREA, because the same way you viewed on a MSGBOX and I do not show anything.

5

Hello

Instead of .StringValue I use .NativeValue