[DUG]: Filters

2003-10-01 Thread vss
Hi All.
Hey I was just on Torrys looking for a control, when I stumbled onto this 
control, "FilterGrid v.1.0" that is a "DB Grid with filter on columns."
Its REALLY good ! the Filters are just under the column headers. AND its 
a free grid too !

Jeremy

---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/


Re: [DUG]: Filters

1999-04-18 Thread Peter Hyde

Andrew wrote:

> Simple one hopefully ? Does anyone know the syntax for using a date in a
> filter expression. I've tried heaps of formats and it always tells me my
> expression is invalid. This doesn't appear to be well documented.

One of my old apps has this code in it, which should help sort it 
out. I know it works as-is under at least two different date 
formats, so the general approach would be to use the current OS 
format for the date string, I believe.

Filter := 'Last_Used >'+DateToStr(date-30);



cheers,
peter


Peter Hyde, SPIS Ltd, Christchurch, New Zealand 
* TurboNote: http://TurboPress.com/tbnote.htm
  -- small, FREE and very handy
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
Find all the above and MORE at http://www.spis.co.nz
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz



Re: [DUG]: Filters

1999-04-18 Thread pjones




This is the code I have for filtering an activity log :


  FSEventViewer1.GetNavDataSet.Filter :=
'LOGDATE >= ''' + FormatDateTime('dd/mm/', DateTimeBegin.Date) +
''' AND LOGDATE <= ''' + FormatDateTime('dd/mm/', DateTimeEnd.Date)
 + '''';

This replies on having the bde date format mode set to 1.






Andrew Masters <[EMAIL PROTECTED]> on 19/04/99 11:25:11

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc:    (bcc: Peter Jones/Logistics&Information
  Technology/Christchurch/Foodstuffs)
Subject:  [DUG]:  Filters




Simple one hopefully ? Does anyone know the syntax for using a date in a
filter expression. I've tried heaps of formats and it always tells me my
expression is invalid. This doesn't appear to be well documented.

Thanks
Andrew Masters
Clinical Solutions Ltd
Auckland, NZ
Ph: +64-9-476-0106
Fax: +64-9-476-0108
e: [EMAIL PROTECTED]

---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz






---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz



[DUG]: Filters

1999-04-18 Thread Andrew Masters

Simple one hopefully ? Does anyone know the syntax for using a date in a filter 
expression. I've tried heaps of formats and it always tells me my expression is 
invalid. This doesn't appear to be well documented.

Thanks
Andrew Masters
Clinical Solutions Ltd
Auckland, NZ
Ph: +64-9-476-0106
Fax: +64-9-476-0108 
e: [EMAIL PROTECTED]

---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz