?
Solved

Ignoring case in Delphi field

Posted on 2010-09-20
13
Medium Priority
?
1,337 Views
Last Modified: 2012-05-10
I'm using the following code in a form that lets users search multiple fields through delphi's filters to find certain records and display them in a grid.

sContractor := '%' + cbContractor.Text + '%';
sStreetName := '%' + edStreet_Name.Text + '%';
sBuyer := '%' + edBuyer.Text + '%';

with gvresults.DataController.Filter do begin
      Clear;
      Root.BoolOperatorKind := fboAND;
     
      if cbContractor.Text <> '' then    AddItem(Root,gvResultsContractor, foLike, sContractor , sContractor);
      if edStreet_Name.Text <> '' then   AddItem(Root,gvResultsStreet_Name, foLike, sStreetName , sStreetName);
      if edBuyer.Text <> '' then         AddItem(Root,gvResultsBuyer, foLike, sBuyer , sBuyer);

So far I've worked out how to include 'wildcards' in the search, but I haven't worked out how to make the fields ignore the case of the character string entered by user--I assume it needs to be done when the variables are declared though...
     
0
Comment
Question by:Bianca
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +3
13 Comments
 
LVL 1

Expert Comment

by:CesarHdez
ID: 33718209
Hi Prec94513, try applying upper(FIELDNAME) = 'SOMETHING', this will not affect how you display the data on your grid

Hope this works,

Cesar
0
 

Author Comment

by:Bianca
ID: 33718305
Hi Cesar.

Where exactly would I put that code in for it to work? I've tried a few ways but none seem to work (though it may be a syntax problem on my part).

Thanks.
0
 
LVL 1

Expert Comment

by:CesarHdez
ID: 33718843
Hi, for a start you need to convert your compare variables to uppercase

sContractor := '%' + UpperCase(cbContractor.Text) + '%';
sStreetName := '%' + UpperCase(edStreet_Name.Text) + '%';
sBuyer := '%' + UpperCase(edBuyer.Text) + '%';

with gvresults.DataController.Filter do begin
      Clear;
      Root.BoolOperatorKind := fboAND;

      (gvResultsX where do you build it?)

      if cbContractor.Text <> '' then    AddItem(Root,gvResultsContractor, foLike, sContractor , sContractor);
      if edStreet_Name.Text <> '' then   AddItem(Root,gvResultsStreet_Name, foLike, sStreetName , sStreetName);
      if edBuyer.Text <> '' then         AddItem(Root,gvResultsBuyer, foLike, sBuyer , sBuyer);

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 5

Accepted Solution

by:
briangochnauer earned 1000 total points
ID: 33719756
             gvresults.DataController.Filter .Options := [fcoCaseInsensitive];
0
 
LVL 1

Expert Comment

by:CesarHdez
ID: 33719861
ah, that's even better! nice one
0
 
LVL 8

Expert Comment

by:GeneralTackett
ID: 33721424
easiest way is to uppercase() both sides or upper()  or use ansicompare with the ignore case option
0
 
LVL 9

Expert Comment

by:auke_t
ID: 33724391
looking at your sourcecode you're using the Developer Express grid.
In that case briangochnauer answer should work (if you remove the space) if you put it in (for instance) the OnCreate of the form.

gvresults.DataController.Filter.Options := [fcoCaseInsensitive];

You can also set it in during design in the object inspector.
0
 
LVL 6

Expert Comment

by:saravananvg
ID: 33740657
Hi,
  As GeneralTackett says, you need to compare it on both sides as follows.

 UpperCase(sContractor) := '%' + UpperCase(cbContractor.Text) + '%';
 UpperCase(sStreetName) := '%' + UpperCase(edStreet_Name.Text) + '%';
 UpperCase(sBuyer) := '%' + UpperCase(edBuyer.Text) + '%';

with regards
Padmaja.
0
 
LVL 6

Expert Comment

by:saravananvg
ID: 33740667
Hi
  Sorry, need to compare it on both sides with if statement.

with regards,
Padmaja.
   
0
 
LVL 1

Expert Comment

by:CesarHdez
ID: 33745222
saravananvg, the code you posted is not actually correct, what Prec94513 is doing there, he is assigning the text on cbContractor to sContractor, so making an UpperCase(sContractor) := '%' .... does not works...
0
 
LVL 8

Expert Comment

by:GeneralTackett
ID: 33745899
you could change the ands for ors if you like.. .or any combination given that you put parenthesis around the sections accordingly...


if ( (UpperCase(sContractor) ) =( '%' + UpperCase(cbContractor.Text) + '%')) and
( UpperCase(sStreetName) )=( '%' + UpperCase(edStreet_Name.Text) + '%')) and
( UpperCase(sBuyer))=( '%' + UpperCase(edBuyer.Text) + '%'))
then begin
.....
end
else begin
...
end;
0
 
LVL 9

Expert Comment

by:auke_t
ID: 33751447
The original poster is using the Developer Express Quantum Grid as you can see by the '.DataController.Filter' part of the code (google it and you'll see). If you are not familiar with that component chances are that all of your well ment advice is actually making things more difficult, as the filter of that grid has a special property (fcoCaseInsensitive) to ignore case in the filter statement.

Setting that property will solve all the OPs problems.

From the helpfile:

Unit
cxFilter

TcxFilterCriteriaOption = (fcoCaseInsensitive, fcoShowOperatorDescription, fcoSoftNull, fcoSoftCompare, fcoIgnoreNull);

Description
The TcxFilterCriteriaOption represents an enumeration of values that control data filtering.  The following table describes the possible options.  Filter options are supported by the TcxFilterCriteria.Options property.

Value      Meaning

fcoCaseInsensitive      Specifies whether filtering is case sensitive.  When this flag is active in the TcxFilterCriteria.Options property, filtering does not distinguish upper and lowercase characters.

fcoShowOperatorDescription      If set, replaces operator symbols with their corresponding text representation.For instance, the ‘=’ operator is replaced with the ‘equals’ string.  Operator descriptions are defined in the cxFilterConsts.pas source file.

fcoSoftNull      If set, empty strings are considered as NULL values when comparing.

fcoSoftCompare      If set, no exception is thrown when comparing values of incompatible types.

fcoIgnoreNull      If set, NULL values are ignored when comparing and are excluded from the filtered results.
0
 
LVL 5

Expert Comment

by:briangochnauer
ID: 33753364
The author of this question has not been involved.??
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question