File Release Notes and Changelog

Release Name: 2.0.7

Release Notes

Download the file corresponding to your architecture.

Linux:

  1. Put the pfm-2.0.7-linux-x86.tar.gz file that you have downloaded
     in a temporary location and open a terminal window.

  2. Unpack that file using

     tar --extract --gunzip --file=pfm-2.0.7-linux-x86.tar.gz

  3. cd to the directory pfm-2.0.7-linux-x86 that was created as a
     result from the extract operation.

  4. If you want to install pfm at system level, login as root by typing

     su

     Note: On some Linux systems (such as Ubuntu), you cannot login as
           root using 'su'. On these systems, immediately start the
           installation script by typing

           sudo ./install.tcl

           Then continue at point 6.

  5. Start the install.tcl script by typing

     ./install.tcl

  6. Just answer a few questions and that's it!

Windows:

Just run the executable

pfm-2.0.7-windows-32.exe

that you have downloaded.

After installing you may need to change the psql option such that
pfm can find the psql.exe program of PostgreSQL.

Change Log

New version of pgintcl: 3.4.0

Bugs fixed:

  1.  Nr          : 1071
      Title       : Tables in schemas other than public
      Description : Tables in schemas other than the 'public' schema cannot be accessed by pfm forms.
                    
                    This is caused by the way pfm encloses tablenames in double quotes when
                    constructing SQL statements.
                    
                    If the form definition has myschema.mytable as tablename, pfm uses
                    "myschema.mytable" in the SQL statements it constructs.
                    
                    This should be "myschema"."mytable" instead.
                    
      Type        : error
      Priority    : medium
      Against     : 2.0.6
      Promised    : 2.0.7
      Status      : reported
      Solution    : 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.
                    
                    Example 1:
                    
                    tablename in pfm_form: "first.last"
                    
                    The tablename in pfm_form contains double quotes. So pfm does not touch it.
                    
                    SQL statement generated in update statement
                    
                        UPDATE "first.last" SET "Name" = 'Jones'
                        WHERE "Nr" = 5
                    
                    Example 2:
                    
                    tablename in pfm_form: myschema.mytable
                    
                    The tablename in pfm_from does not contain double quotes. So, pfm considers
                    the dot as a word separator.
                    
                    SQL statement genereated in update statement
                    
                       UPDATE "myschema"."mytable" SET "phoneNumber" = '06 874 89 90'
                       WHERE ("id" = 1072)
                    
      Originator  : Martin Hoffmann
      Date        : 2011-09-27

  2.  Nr          : 1072
      Title       : pfm ignores the orderby attribute in pfm_link
      Description : pfm ignores the orderby attribute in pfm_link.
      Type        : error
      Priority    : medium
      Against     : 2.0.6
      Promised    : 2.0.7
      Status      : reported
      Solution    : method 'followLink' of class 'FormTab' is corrected.
      Originator  : wim
      Date        : 2011-09-27

  3.  Nr          : 1073
      Title       : Tcl run time error when opening empty listbox
      Description : Class ListBox in source misc.tcl causes a Tcl run time error when displaying
                    an empty ListBox.
      Type        : error
      Priority    : medium
      Against     : 2.0.6
      Promised    : 2.0.7
      Status      : reported
      Solution    : Constructor of class ListBox tests for empty valuelist.
                    
                    If valuelist empty, pfm does not attempt to set focus to a list item.
      Originator  : wim
      Date        : 2011-09-27
Powered By FusionForge