Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Using CLOB fields
Sat, Oct 27 2018 3:52 AMPermanent Link

Hershcu Sorin

Hello

I have a table with CLOB field
I want to select the value of this fields and store it on a var.
(myVar := myTable.FieldsByName('myCLOBfield').As...)

I can't figure what types I suppose to use?
Thanks Sorin
Sat, Oct 27 2018 10:40 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Hershcu


Depends on MyVar. If its a string:

MyVar := myTable.FieldsByName('myCLOBfield').AsString;

if its a TStringList either

MyVar.Text := myTable.FieldsByName('myCLOBfield').AsString;

or

MyVar.Assign(:= myTable.FieldsByName('myCLOBfield'));


Roy Lambert
Image