What's new in Postgres Forms 2.0.7
Feb 8, 2013
- Tables in schemas other than public - The way pfm quotes tablenames is modified as follows.
- If the tablename in pfm_form already contains double quotes, pfm does not touch it.
- If the tablename in pfm_form does not contain double quotes, pfm encloses every dot in double quotes and puts double quotes around the whole tablename.
- pfm ignores the orderby attribute in pfm_link - method 'followLink' of class 'FormTab' is corrected.
- Tcl run time error when opening empty listbox - Constructor of class ListBox tests for empty valuelist. If valuelist empty, pfm does not attempt to set focus to a list item.
New in Postgres Forms 2.0.6 (Feb 8, 2013)
- Attribute names with more than one word - This is caused by a bug in Itcl (Version 3.4b1, patchLevel 3.4.0).
- If an object instance variable is an array element with a name consisting of two words and if that variable is bound to an entry widget, the array element's value is not displayed in the entry widget.
- If a global variable is an array element with a name consisting of two words and if that variable is bound to an entry widget, the array element's value is displayed allright in the entry widget.
- A work around is implemented in pfm.
- Instead of binding record($attrib) directly to the form's entry widgets, record($recordIdx($attrib)) is bound to the form's entry widgets where recordIdx acts as a conversion table which maps the attribute names ($attrib) to integers.
New in Postgres Forms 2.0.5 (Feb 8, 2013)
- The aggregate function STDDEV has been modified to be in line with the definition used by PostgreSQL. In previous versions, pfm used the "population standard deviation"
- SQRT (SUM( (value_i - AVG(value))**2 ) / N )
- whereas PostgreSQL used the "sample standard deviation"
- SQRT (SUM( (value_i - AVG(value))**2 ) / (N - 1) )
- From now on pfm also uses the "sample standard deviation"
- The included Tclkit and Pgintcl have been upgraded to versions 8.5.9 and 3.2.1 respectively.
- Since version 2.0.5, I don't include binaries for the 64-bit architectures anymore.
- On Windows replace the installed 32 bit binaries tclkit.exe and tclkitsh.exe in the pfm installation directory with their 64 bit variants. Make sure that they are still called tclkit.exe and tcklkitsh.exe.
New in Postgres Forms 2.0.4 (Feb 8, 2013)
- Run time error in get parameters for report - This is caused by an error in the constructor for class ParmObject in source report.tcl.
- There is a loop which defines a label and an entry for each parameter, but this loop lacks an "incr idx", which causes all labels and entries to be defined with the same name. Adding an "incr idx" ate the end of the loop, solves this problem.
New in Postgres Forms 2.0.3 (Feb 8, 2013)
- The connection with 'psql' fails on the Windows version with PostgreSQL 8.3 - This error is corrected in method 'connect_sql' in postgresql.tcl.
- Background colours wrong on some systems - This is corrected in procedure installTheme by adding:
- option add *Entry.background {White}
- option add *Text.background {White}