CHMlib Logo Leading Translation Management System for Translation Agencies, Top Translation Management Software for Freelance Translators, Time Tracking Software, Word Count, Character Count and Line Count Software, Computer Assisted Translation Tool for Easy Word Count, Clipboard Character Count Software, User-Friendly Translation Memory Software, Terminology Management Software, Terminology Management Server, Microsoft Glossary Software, Dictionary of Acronyms, Social Network for Translators and Translation Agencies, Acronyms and Abbreviations Search Engine, Russian Translation Lab, Ukrainian Translation Lab.
You are reading help file online using chmlib.com
PSCGetCalendarFilterStrEx

PSCGetCalendarFilterStrEx function

Generates the filter condition for Date field on the base of a set of selected dates.

function PSCGetCalendarFilterStrEx(Const SelStart, SelFinish: TDateTime; Const DateField: String; AParams: PPSCGetCalendarFilterStrParams): String;

Unit
psc_calendar

Description
Use PSCGetCalendarFilterStrEx when you need to create SQL WHERE clause from the set of dates. Conditions will be constructed for the field indicated in DateField parameter. Parameters SelStart and SelFinish must specify the range of dates in a set. Function will have the access to the set of dates through callback function that must be specified in DateSelectedProc parameter. Callback function will receive as a parameter date and must return True if it is in the set of fields or False in other case. Parameter DateFormat must specify the format of date in SQL clause. Through OrStr and AndStr parameters PSCGetCalendarFilterStrEx function receives the information about local settings for OR and AND reserved words.

You can leave OrStr and AndStr parameters empty then OR and AND constants will be 'OR' and 'AND' corresponding. If DateFormat parameter is nil then DateTime format will be obtained from windows local settings.

Note: If there is a successive line of more that three days in the set of dates PSCGetCalendarFilterStrEx rolls it up in a complex condition.

For example :
Line of dates : '01/02/99, 02/02/99, 03/02/99, 04/02/99, 07/02/99' for field 'ShipDate' will be rolled up in '( ( ShipDate >= 01/02/99 ) AND ( ShipDate < 05/02/99 ) ) OR ( ShipDate = 07/02/99 )' condition.

Generated by Putersoft.FreeHelp. Copyright © 1999-2002. puterSoft.Com
You are reading help file online using chmlib.com

If you want your help file to be removed or added please send e-mail to chmlibcom@gmail.com