Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

delphi XE2 Ado Filter problem

Status
Not open for further replies.
MLNorton

MLNorton

Programmer
Nov 15, 2009
134
US
What is wrong with this filter statment?

Form_Main.ADOTable1.Filter := 'Active = ' + quotedStr('A') or
'Active = ' + quotedStr('B');
 
Sort by date Sort by votes
Probably lack of quotes around the "or"
Code: 
Form_Main.ADOTable1.Filter := 'Active = ' + quotedStr('A') +' or Active = ' + quotedStr('B');
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

delphi2024
  • Locked
  • Question
delphi xe8 Pls help copy the bold richedit1.text goin to edit1.text
Replies
1
Views
265
delphi2024
delphi2024
RElmaaroufi
  • Locked
  • Question
After programming in Delphi since i
Replies
6
Views
325
RElmaaroufi
RElmaaroufi
WolfstarUA
  • Locked
  • Question
Filtering AdoTable + dbrichedit
Replies
1
Views
159
DjangMan
DjangMan
nosty1741
  • Locked
  • Question
Some Struggles with Delphi 10.4 Community edition
Replies
1
Views
274
majlumbo
majlumbo
Crytach
  • Locked
  • Question
Delphi ADOTable help.
Replies
1
Views
163
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top