A number of features have been implemented in the API TTCHARTDLL in order to customize the color of the lines on the ordinate and abscissa (ChartSetXAxisColorLabel, ChartSetYAxisColorLine), customize the text color of the labels of the X axis (ChartSetAxisColorLabel), showing label elements as tooltips (ChartShowElementLabelAsTooltip), indicate the maximum and minimum values of the scale of values (ChartSetViewDataRange) and indicate the decimal scale of these labels in the ordinate (CharSetYAxisLabelPrecision).
A new environment variable has been implemented (FETCHLASTBEFOREEDITNEW) in order to fetch the last row of the grid in the lines table in a header-lines form after the EditNew method of the FormTable class has been executed and the value of the QUERYBUFFERING environment variable is TRUE. Thus, the apparent loss of lines can be avoided.
It has been implemented the ability of changing the value of the Background property (background color) and Foreground property (foreground color) in a Multiline EditField.
A new environment variable has been implemented (EDITDISABLEDCTRTEXTCOLOR) in order to change the background color in all the disabled Text controls that are not owned by a FormTable.
In this version there have been improvements in the following components:
The following environment variables have been implemented:
FETCHLASTBEFOREEDITNEW. If it's value is TRUE, the cursor will be positioned in the last record of the table when the EditNew method of the FormTable class is executed.
EDITDISABLEDCTRTEXTCOLOR. This environment variable allows to define the text color of the controls of type Edit Field, Drop Edit and Drop List that are disabled (property Disabled= TRUE).
HIDECOLUMNIFNODETAIL. This environment variable allows you to specify if the columns that don't belong to a break-group or aggregates will be hidden or shown.
GWSENDLABELINDESCRIBE. When the SqlDescribe method of the SqlServer Class is executed, this environment variable tells the runtime that it should return de column alias in expression type columns.
MINIMIZEFORMCASCADE. This environment variable tells the runtime that if a window is minimized the parent windows will be mini-mized .
This environment variable can be defined in the cosmos.ini file or the project's configuration file.
DBCONNBLOCKSIZE. This environment variable tells the runtime the connection buffer size in bytes in a connection with CTSQL, Gworacle or Gwinformix.
CharShowElementLabelAsTooltip.This function allows to show a tooltip with the element’s label when the mouse pointer is over a element.
ChartSetXAxisColorLabel.This function allows to define the text color of the X-axis labels.
ChartSetXAxisColorLine.This function allows to define the color of the X-axis lines.
ChartSetYAxisColorLine.This function allows to define the color of the Y-axis lines.
ChartSetViewDataRange.This function allows to set de minimum and maximum display values of the scale of values in the ordinate axis.
CharSetYAxisLabelScale.This function allows to indicate the numeric scale (number of decimal values) of the values in the labels of the ordinates axis.
SetListColorByLevel.This method allows to set the background color in the different levels of the grouped Lists to make an easier display.
EnableListColorByLevel.This method indicates to the runtime that the colors defined with the SetListColorByLevel method will be displayed.
SetGridColumnDisabled.This method allows to change the disabled property in the Grid controls.
SetTextDireccion.This method allows to set the text orientation in a TEXT control.
SetTextHorinzontalAlign.This method allows to set the horizontal text align (left, center, right) in the TEXT controls.
SetTextVerticalAlign.This method allows to set the vertical text align in the multiline TEXT controls.
ToChar. This method returns a formatted string as from a date type object with a format template received as parameter.
FromChar. This method assigns a formatted string-date to a date type object.
DECODE.This function compares the parameter expr with every one of the search values one by one. If expr is equal to a search value, returns the corresponding value.
This function works like a “if xxx then xxx” or a “switch-case” into the select statement.
NVL.This function compares expr1 with NULL. If expr1 is NULL, then will return expr2.
This function works like a “if expr1 == NULL then expr2, else expr1”.
ABS.This function returns the absolute value of a numeric expression in a query.
SIGN.This functions returns -1 if the value of the parameter is a negative number, 1 if the parameter is a positive number and 0 if it’s value is 0.
TO_DATE.This function converts a character string into a DATE type value from an input format.
In this version, we have performed corrections in the following components: