Search Criteria

[arumalla]

Hi all
I have a question, which is regarding the search component for data base through the form. my problem is when I try to search through the menubar >> Select >> Find... I have to be very carefull to use the search because it is case sensitive also it won't search with the part of a search word ( like, we have to give "SynPep Corp." to search for the "SynPep Corp." data even with the period, its not taking just the "synpep" or else to get the records of SynPep.)
Is there any thing I have to modify for the existing search like properties for the form ... or should I have to redesign the search criteria for the form??
I think I am explaining this too much.....
I just need a search criteria which is capable of making search based on part of the word and non case sensitive...??? how can I?

[automazione]

The solution should be a search on #%synpep%

where

%synpep search records that ends with synpep (case sensitive)
synpep% search records that start with synpep (case sensitive)
%synpep% search records that contains synpep (case sensitive)
#%synpep% makes the search Case Insensitive.

Hope this helps.

I found it on:

http://developer.servoy.com/docs/developer/index.htm

in section "getting started" - "finding data". Note for Servoy doc-team: "A pair of extra search examples would be appreciated - thanks"

What I do not know is how to do a search for an empty text field, or for someting bigger than "aaa" or smaller then "xxx"


bye

Enrico Arata

[arumalla]

The solution should be a search on #%synpep%

where

%synpep search records that ends with synpep (case sensitive)
synpep% search records that start with synpep (case sensitive)
%synpep% search records that contains synpep (case sensitive)
#%synpep% makes the search Case Insensitive.

Hope this helps.

I found it on:

http://developer.servoy.com/docs/developer/index.htm

in section "getting started" - "finding data". Note for Servoy doc-team: "A pair of extra search examples would be appreciated - thanks"

What I do not know is how to do a search for an empty text field, or for someting bigger than "aaa" or smaller then "xxx"


bye

Enrico Arata

cool
But in future should we expect a liberated search criteria...? with out those "#, %'s"....
Is that be a nice enhancement.....

Thanks Enrico Arata...

[maarten]

additional notes:

1) look for empty fields "=" (without quotes)
2) leave out empty fields "!=" (without quotes)


issues:
- When you search for empty fields, null fields will not appear.
In SQL there's a difference between null and empty
When you create a record, a field can be null (no data at all).
But when you edit the field, and decide to empty it, (or just klick in and out of it) it becomes a empty "String",. From that moment on, it responds to searches on empty fields.
I'll discuss with dev team, how we're gonna handle nulls.
- search >"Aa" is not working yet. Will try to implement asap.

Thanks