TStringField and TMemoField

[Crusher]

I am using TOraclewwwDataSet and InfoPower TwwDBgrid.

The DataSet connect to a table with two huge varchar2. They are:

ErrorMsg : varchar2(4000)
UComment : varchar2(4000)

In the field section of the DataSet they are represented as TStringField. However I would like to change them to TMemoField. But I would rather not change Session.Preferences.MaxStringFieldSize since the session used by the dataset is a global defined used by many parts of a large program.

I have tried manually to change the *.dfm and *.pas file from TStringField to TMemoField, but this gives me an error upon activation of the dataset.

What are my options?

 

[Marco Kalter]

I don't think there are any other options than TOracleSession.Preferences.MaxStringFieldSize. You could set it to 3999 to minimize the effect on the rest of the application. This doesn't help if 9 out of 10 large varchar2 columns have a length of 4000 of course.

------------------
Marco Kalter
Allround Automations