Q: Where and how to use FIBPlusTools?
A: Unique tools: FIBPlusTools
Besides components FIBPlus has additional tools FIBPlus Tools, which extend IDE features and enable you to use FIBPlus at design-time more effectively.
Preferences help you to set default parameters of the main components. On the first dialog page you can set default values for Options, PrepareOptions and DetailsConditions for all TpFIBDataSet components. You can also set certain keys for these properties. For example if you make SetRequiredFields active, then placing a new TpFIBDataSet component onto the form, you will see that its PrepareOptions property will have pfSetRequiredFields defined. It is important that default settings in FIBPlus Tools Preferences are valid for all new applications that you create. Notice that this concerns only initial defaults: if you change component properties after dropping the component onto the form, Preferences won’t have these changes. Besides when changing Preferences, you do not change components which properties were already defined.
Picture 8. Tools Preferences.
Prefix Generator name and Suffix Generator name fields are important. Setting them you can form generator names in the AutoUpdateOptions property in TpFIBDataSet. The generator name in AutoUpdateOptions is formed from the table name (UpdateTable), its prefix and suffix.
The following dialog pages help to define main properties for TpFIBDataBase, TpFIBTransaction and TpFIBQuery. In particular if you always work with newest InterBase/Firebird versions (e.g InterBase version 6 upwards), set SQL Dialect=3 in TpFIBDatabase, then you won’t need to set it manually all the time.
It’s the most interesting part of FIBPlus Tools which has no analogues in other products. This tool helps to handle SQL centrally for the whole application.
SQL Navigator enables you to have access to SQL properties of any component from one place.
The button «Scan all forms of active project» scans all application forms and selects those which contain FIBPlus components for work with SQL: TpFIBDataSet, TpFIBQuery, TpFIBUpdateObject and TpFIBStoredProc. Select any of these forms. The list in the right will be filled with components found on this form. Of you click any component you will see their corresponding properties with the SQL code. For TpFIBDataSet there will be shown such properties as SelectSQL, InsertSQL, UpdateSQL, DeleteSQL and RefreshSQL. For TpFIBQuery, TpFIBUpdateObject and TpFIBStoredProc FIBPlus will show an SQL property value.
You can change any property directly from SQLNavigator and its new value will be saved. SQLNavigator helps to work with groups of components. You only need å select corresponding components or forms.
“Save selected SQLs” saves values of selected properties into an external file.
“Check selected SQLs” checks selected SQL queries on correctness in SQLNavigator.
Then you can analyze the file with selected queries by using special tools.
You can also use SQLNavigator for text searching in the SQL of the whole project.
By double clicking any found item you make SQLNavigator select a component and a property and thus can edit SQL.
Picture 9. Tools SQL Navigator
During a re-write of a very large software system we were having some difficulties utilizing a 3rd party grid that we had chosen. The dataset connectivity was very flaky due to the complex joins and updates we were using which caused the grids to behave very sketchy. FIBPlus was the perfect solution for us. After implementing it everything became so much easier. The grid functionality stabilized, data retrieval was much faster, and we were pleasantly surprised by many of the unique features of your components. We were especially impressed with your pFIBUpdateObject components which allowed us to very easily update the multiple tables we were using in our joins. Many thanks for your great components.>>