Board index » delphi » TQuery is Case Sensitive on Paradox

Steve Stone

Delphi Developer
Mon, 25 Sep 2000 03:00:00 GMT

TQuery is Case Sensitive on Paradox

Dumb question??
My  TQuery will only return exact string matches.
Select * from Name where Name.fname='Steve'

records with steve will not be returned.
I can't see any way to change this.
Using Access this same statement works fine.
help

Thanks,
Steve

 
Timothy J. Kell

Delphi Developer
Mon, 25 Sep 2000 03:00:00 GMT

Re:TQuery is Case Sensitive on Paradox


Quote
Steve Stone wrote:

> Dumb question??
> My  TQuery will only return exact string matches.
> Select * from Name where Name.fname='Steve'

> records with steve will not be returned.
> I can't see any way to change this.
> Using Access this same statement works fine.
> help

> Thanks,
> Steve

Try

Select *
from Name
where (UpperCase(Name.fname) = Uppercase('Steve'))

Steve Ston

Delphi Developer
Mon, 25 Sep 2000 03:00:00 GMT

Re:TQuery is Case Sensitive on Paradox


I get a DBE error  "Capability not supported"

I'm open to any other ideas

Thanks

Steve

Quote
Timothy J. Kelly wrote:
> Steve Stone wrote:

> > Dumb question??
> > My  TQuery will only return exact string matches.
> > Select * from Name where Name.fname='Steve'

> > records with steve will not be returned.
> > I can't see any way to change this.
> > Using Access this same statement works fine.
> > help

> > Thanks,
> > Steve
> Try

> Select *
> from Name
> where (UpperCase(Name.fname) = Uppercase('Steve'))

Craig Wilso

Delphi Developer
Tue, 26 Sep 2000 03:00:00 GMT

Re:TQuery is Case Sensitive on Paradox


Quote
> Timothy J. Kelly wrote:
> > Try

> > Select *
> > from Name
> > where (UpperCase(Name.fname) = Uppercase('Steve'))

I believe the correct syntax is
  SELECT * FROM NAME WHERE UPPER(Name.FName) = "STEVE"
"Uppercase" is the Delphi Pascal version.
TWIN SOFTWAR

Delphi Developer
Sat, 30 Sep 2000 03:00:00 GMT

Re:TQuery is Case Sensitive on Paradox


Thumb question indeed; use LIKE or UPPER

Koen.

Quote
Steve Stone wrote:
> Dumb question??
> My  TQuery will only return exact string matches.
> Select * from Name where Name.fname='Steve'

> records with steve will not be returned.
> I can't see any way to change this.
> Using Access this same statement works fine.
> help

> Thanks,
> Steve

Other Threads

1. Paradox primary key case sensitive?

2. Paradox cannot create case-sensitive index?

3. Case sensitive problem of Paradox query engine

4. Case-sensitive in Paradox Tables

5. Case Sensitive vs Case-InSensitive

6. Tquery accesses Paradox Case Ignorant

7. Help: FindFirst, Case-sensitive?

8. Like statement case sensitive on Memo field

9. D1: DBF & Non-Case Sensitive Indicies

10. Case Sensitive in Foxpro/Delphi