Find data in TEXT_AREA

Classic Servoy
1

Hello,

is it possible to find data in a form field displayed as TEXT_AREA (stored calculation field)?

In my case it doesn’t work. If I switch the field to displayType TEXT_FIELD it works. Maybe there are some limitations for TEXT_AREA?

Hans-Peter
WinXP
Servoy v2.2.3

2

yes, that is possible!

how are you doing your search? exact?
have your tried with %searchvalue% ??

3

hmm… I’ve tried exact and with %searchValue%.

Attached is a sample solution. If I’m searching the company %Morrison% in field “Calc_company_name”, Servoy is showing all records. If I’m searching the company %Morrison% in field “Calc_company_name2”, Servoy finds the correct record.

Calc_company_name → displayType = TEXT_AREA
Calc_company_name2 → displayType = TEXT_FIELD

Both are stored calculations.

Maybe there are some problems with my javaversion or sybase ASA?

Java Version 1.5.0_06-b05
Sybase ASA 9.0.1
WinXP

Thanks
Hans-Peter

calcExample1.servoy (6.38 KB)

4

Is the calculation STORED or UNSTORED?

If STORED - then the formatting of the field makes no difference.

5

Both are STORED.

6

Hi Hans,

Hmmmm… that’s very strange.

Try this: add a field to your form (based on the same table as your calc) - whose dataprovider is another field. Change the displayType property to a textarea and search again. Same problem?

7

Hi Bob,

yes it is very strange…

Try this: add a field to your form (based on the same table as your calc) - whose dataprovider is another field. Change the displayType property to a textarea and search again. Same problem?

No.

But what I see yet is, if I mark the property “editable” of the TEXT_AREA field (stored calculation), it works. Is this normal?

Thanks
Hans-Peter

8

In Servoy 2.2.4 non editable text/html area are made searchable.