Basic4ppc - Windows Mobile Development  

Go Back   Basic4ppc - Windows Mobile Development > Main Category > Questions & Help Needed
Home Register FAQ Members List Search Today's Posts Mark Forums Read

Questions & Help Needed Post any question regarding Basic4ppc.


Table filter (AND & OR)


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 08-24-2007, 12:37 AM
LineCutter's Avatar
Senior Member
 
Join Date: May 2007
Location: Daarsit
Posts: 117
Awards Showcase
Beta Tester 
Total Awards: 1
Default Table filter (AND & OR)

I want to filter a table with a combination of a date range & several discrete parameters. Does the filter string support brackets?

i.e table.filter("date>"&mindate&" AND date <"&maxdate&" AND (p1=true OR p2=true OR p3=true)")

I don't want rows where P1,P2 or P3 are true, but the date is out of the range. If I can't use brackets then I could use some help avoiding selecting what I want PLUS any rows with P2 or P3 being true.
Reply With Quote
  #2 (permalink)  
Old 08-24-2007, 02:29 PM
specci48's Avatar
Basic4ppc Expert
 
Join Date: Apr 2007
Location: Germany
Posts: 636
Default

Yes, I have already used brackets in my filters...


specci48
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve table filter from the filtered table? LineCutter Questions & Help Needed 1 09-08-2008 07:20 AM
Table.filter problems J12345T Questions & Help Needed 1 08-19-2008 08:19 AM
Filter a table on keypresses Offbeatmammal Questions & Help Needed 5 06-01-2008 08:29 PM
save filter of a table manu Questions & Help Needed 4 08-23-2007 04:46 PM
Table.Filter Phil Budge Questions & Help Needed 2 05-16-2007 10:35 PM


All times are GMT. The time now is 01:04 PM.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0