Whatsnew

Sign Description
+ New feature
- Bug fixed
* Behavior Changed

 

V0.97B (December 7, 1999)
 
+[FB] OnSaveToStream, OnLoadFromStream events

+[FB] LoadFromFileDlgEx, SaveToFileDlgEx, DefStoreMode

+TPSCDateEdit control

+[CA] Czech holidays added

+ now it's possible to enter dates manually in the calendar popup.

+[FB] Values from PickLists are now converted to the proper type
(previously were always FT_STRING)

+[FB] in TPSCFltBld and TPSCFltDlg it's possible to save/load items to stream, file, string, field (through Items' methods SaveTo...,LoadFrom..)

*[FB] TPSCFltBox: SaveTo...,LoadFrom... were moved to the Items so if you
previously called SaveToStream, now write Items.SaveToStream

+[FB] TPSCFltBld.FilterStrChanged property. Also DataSet is not  reopened/modified when items are changed but filter is not.

+[FB] 'yesterday', 'tomorrow'... conditions are more correctly generated (in the case of TDateTime fields). Also system variables for 'today'....etc.
are generated dynamically now (previously updated only on program start).

+[FB] now it's possible to use 'contains', 'begins with', etc. against TTable/TQuery when HookFilterProp is True. Powerful PSCSetDataSetFilterAdv procedure introduced. Now it's possible to use LIKE and other advanced SQL features in dataset's filters!

+[FB] popup list box is resizable now.

+[FB] event OnQuoteStr is added, properties PickTemplSize, PickFieldSize, FilterOptions, FieldNameMask were added.

+[CA] New Greek holidays: Easter,Holy Spirit, Clean Monday.

+[CA] It's possible to specify dckProc kind of holidays in holiday consts and in Holidayitem.

+[CA] OnGetHolidayDate event in calendar.

+[CA] HolidayNames:TStrings and DefaultHolidays:boolean properties. 

+[FB] TPSCFltDlg components.

-[FB] sometimes SaveToFile/LoadFromFile changed string constants due to extra call to DataSet.Translate method in non-English countries.

+Variant property editor implemented (used only under D3)

+ Help files

      
V0.96B (November 9, 1999)

+[FB] TPSCFltBld, TPSCExprEval, TPSCGridColors components added. Please study our new FilterBox demo for some ideas on how to use them.

+[FB] FtBCD fields are supported now in FilterBox.

+[FB] DisplayDateTimeFormat, FilterDateTimeFormat, SQLDateTimeFormat properties published in FilterBox. 

+[CA] Calendar controls were improved a lot (selection, painting, new properties, etc.). 

+[FB] Now it's possible to specify date and time in one popup when TDateTime parameter is picked in FilterBox.

+ String constants localized to Czech, Greek and Russian languages.

+[CA] Greece holidays added in the calendar pro.

+[FB] Now SQL is correctly generated when field names contain spaces or are SQL keywords.

* [FB] As there are some ops like fboCanAdd, fboCanDelete in options, older versions of FilterBox can be by default in read-only mode, To allow add, delete of items and other operations, please edit FilterBox options property and set desired flags there.

-
[FB] exception when FilterBox deleted after SQL property was assigned with property editor at design time.

+
[FB] KeyMapping property. Now it's possible to specify different key mapping schemes for the FilterBox. 

+completely new and improved demo project.

+
[FB] Many new elements in Options property of FilterBox.

* [FB] D4 Actions for FilterBox were removed. If you affected anyhow by this change please contact our tech support for the solution.

* [FB] Lot of functionality of FilterBox were moved to TPSCFltBld component. We tried to leave all property declarations untouched, again if your code affected by this change please contact us for the help. 
 
+TPSCFileOperation and TPSCPathDialog components added.
     
 
V0.95B (October 12, 1999)
 
+ Delphi 3,4,5; C++ Builder 3,4 are supported now.

+ Fields and conditions are sorted by default in FilterBox. 

+ '%' are added when LIKE condition is generated.

+ 'begins with' and 'ends with' are added to default conditions.

+ Lookup parameters are supported now.
 
+ properties ForceSQLDateTime, Options, FilterDateTimeFormat, SQLDateTimeFormat in FilterBox.

- 'is empty' and 'is not empty' conditions by default generated the wrong SQL ('=NULL' instead of 'IS NULL' and '<>NULL' instead of 'IS NOT NULL').

+ New properties in TPSCCalendar: Flat, Colors, ShowWeekNumbers, WorkDays, LongDayNames, SelectKind 

- Calendar: OnDateChanged wasn't called when selection changed.

+ Calendar: Mouse cursor is now changed when mouse is placed over the "before week". MouseCursor property is added.

+ Calendar: Now when user clicks on > or < buttons and holds Ctrl, calendar scrolls by years.

* PSCSysUtils' routines PSCIncWeek, PSCIncDay, PSCIncDate, PSCCorrectAndEncodeDate  are much faster now.

* Calendar: Selection with mouse is more like in Outlook's calendar.

+ Memo fields now have more available conditions to choose from when "1" is in AllowedUsageIDs. You can not use new conditions if FilterBox is used on TTable.Filter or TQuery property cause BDE doesn't support memo fields in filters fine enough, but it works fine when FilterBox is used for SQL generation.

- "Save to Memory" caused exception. This is V0.94B only bug.

* PrmListBox and FltBox are no longer derived from TCustomListBox. Off-screen DC is not used for painting the FilterBox so painting is much faster now.
 
   
V0.94B (Sep 22, 1999)
 
+ Spanish string constants are added (PSC_ESP.INC).

+ PopupMonthListBox, ShowNavButtons, ShowMonthDividers, ShowToday, MaxSelDates, SideWeekSelect properties in calendar.

+ TPSCOrderByItem.DataField property editor implemented.
(OrderByItems.DataField property of FilterBox)

+ Arrow keys work now in calendar. Also it possible to change selected dates with Shift+Arrows.

+ Calendar painting speed is dramatically improved.

+ Now it's possible to select not connected dates in calendar (when multiselect is on) with Ctrl+mouse.

+ property SelDate[DateTime:TDateTime]:Boolean in calendar.

+ event OnGetPaintParams implemented in calendar. Now it's possible to specify colors and font styles for the specific dates.

+ property AdditionalFilter in FilterBox. Added before generated filter. So Result_Filter=AdditionalFilter + ' AND ' + Generated_Filter.

+ Filtered property added to FilterBox. When Filtered=False FilterBox's FilterStr returns empty string even if there are filter conditions.

+ BtnPanel has an additional property DefButtonSet where you can specify exactly what buttons will appear on the panel (If DefButtons=pbFromSet).

+ BtnPanel.UseMainFormFont (when True form's font will be set to main's form font).

- PickList from FieldParams was ignored in FilterBox.

+ FilterBox tested with different combinations of SysUtils' DecimalSeparator and win32's DecimalSeparator and changed in order to work fine in all cases.
 
 + New properties TPSCCalculator.Enabled, TPSCCalculator.Precision, TPSCCalcDisplay.Enabled.

+ Design time property editors for LookupKeyField and LookupDisplayField props of TPSCListParam; LookupKeyField, LookupDisplayField and TemplCat props of TPSCFltBoxField and TPSCFltBoxTemplate.Category
are implemented and registered for use in Inspector.

+ ModifyDefaultTemplProc variable added. It's called after 'default templates' were assigned (just in case you need to modify default templates).

* TParams are no longer used in FilterBox cause D3 and D4 TParams are not compatible. Now we use TPSCFields instead of TParams. Because of this change you need to open your forms as text and to remove any Filter Box's items (Items property) added at design time from the FilterBox. After you remove item you can open your form with FilterBox safely.

+ Delphi 3 support is added.
  
V0.93B (wasn't released)

+ InitialDir property added. Now it's possible to specify an initial dir for built-in Open/Save dialogs. By default it's equal to '%APPFOLDER%'.

* True/False for display purposes are taken from dbconsts TTextFalse, STextTrue. SPSCBoolFltFalse, SPSCBoolFltTrue are added and used when FilterStr/SQL is generated. This is done to fix bug in localized version of FilterBox (localized True/False appeared in the query instead of English True/False).

- Ctrl+Del, Ctrl+S, Ctrl+O, Ctrl+Shift+O, Ctrl+Shift+L work as expected now.

+ 'Hide Comps' expert added. Now when you press Ctrl+Alt+H in Delphi/C++ Builder, active forms' non-visual components will be temporarily hidden (press Ctrl+Alt+S to show them back).
V0.92B (wasn't released) 

+ When you use the actions from PCS, images are now added to the ImageList associated with ActionList. 

- When Filter Box's Font.Color=clWhite items in popup listbox where invisible.

+ Now FilterBox is invalidated when Font property is changed.

+ When HookFIlterProp/HookSQLProp=True Table/Query are assigned with FilterStr only when FilterStr was actually changed (previously after any user change in FilterBox).

- It was impossible to use FilterBox with fields defined in Fields property (conditions list was empty).

+ NewItemChecked property.

+ ";" can be used in the AllowedUsageIDs property (previously only "," was allowed).

+ TPSCBtnPanel control

+ MergePopupMenus property.

+ Ok, Cancel, Delete buttons are localized in the forms. Forms' font is set to the main form's font.

* SErrMemSlotDelete, SPSCPrmBoxEditor moved to inc file.

- NOT LIKE condition now correctly recognized by AI when FilterStr is assigned. 

* Condition 'not contains' produces 'NOT (% LIKE %)' instead of '% NOT LIKE %'.

+ Easy integration with TQuery, FilterBox properties: ActivateDataSet, SQLHead, SQLTail, OrderByItems, SQL, SQLOBTail, WhereInc, HookSQLProp.

+ German language is supported now.

+ TPSCParser and TPSCSQLParser
  
V0.91B
  
+
TPSCCalculator and TPSCCalcDisplay controls are added

+ Calculator integrated in the PSCFilterBox.

+ 'And' and 'Or' operations can be localized now. In the 
TPSCFltBoxItem.Operation display name is stored and filter 'and' and 'or' are converted from display operation with DispToFiltOperation() function (virtual) [by default returns SPSCOperationFltAnd/SPSCOperationFltOr].

+ More strings are moved to 'resourcestring' section of the pscconst.pas. If you feel that some const need to be moved there please write us. 

+ TPSCCalendar control is improved a lot and published on component palette.

+ Demo improved.

+ Ordering information added (file order.txt).

- Assigning of an empty string with #10#13 at the end to FilterStr caused exception.

+ PSC_ENG.INC file. All resourcestrings are moved there

+ More conditions are shown in popup for AUTOINC fields. 

- No exception when assigning float value to integer parameter (value is rounded before assignment).
  
V0.90B
  
First public release.