[DUG]: Filters
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
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
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
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