5.6.09 Release Notes

(All)
    The SYSTEM() function would give a syntax error on some platforms.

(All) #1063
    blobfix now takes command line parameters:
        blobfix [filename | -] ( -m qualifier )

(Windows) #1074
    fpcopy would give a "cannot create new file" error upon doing a "copy
    file formats only".

(Quickstart only) #1104

    Executing a LOOKUP in a processing table, CALLing another table
    which executes a LOOKUP to the same file, and then CLOSEs that
    lookup, can cause filePro to crash and/or give unusual errors
    upon re-executing the LOOKUP in the original processing table.

(All) #1105
    The configuration editor did not allow an equals sign to appear in
    the value of a setting.

(All) #1106
    Under certain circumstances, CLOSEDIR() could cause filePro to hang
    or crash.

(All) #1108
    A new config variable, PFPRTFIND=logfilename, was added to help
    debug problems in resolving printer name to destination.

(All) #1109
    In request output, if you execute a CALL in sort/select processing,
    and then execute a CLOSE in output processing with no intervening
    CALLs, filePro would crash.

(All) #????
    The SYSTEM() function would give a syntax error on some platforms.

(All) #596
    blobfix did not properly fix qualified blob files.

(fPSQL) #701
    fPSQL queries that selected based on associated fields behaved 
    differently if an index was built on that associated field group.

(All) #865
    Selection sets did not properly compare memo fields no empty.
    For example, if field 6 is a memo field:
        6  ne   <nothing>
    all recods would be selected, even those where field 6 is empty.

(All) #1078
    fpconfig did not allow values which contained an equals sign ('=').

(SCO OSR5) #1031
    fpcopy on SCO OSR5 did not copy files whose name was longer than
    14 characters.

(fPSQL) #1060
    fPSQL on some systems would crash on queries using associated fields.

(All) #1067
    dxmaint did not override PFQUAL of passed -m "" on the command line.

(All) #1094
    A printer with a destination of "LOCAL" was not recognized as
    setting the destination to the local printer.

(fPSQL) #1111
    fPSQL could not use "filename.fieldname" format if the filename
    started with a digit.
    Note that, with this change, invalid numeric literals such as
    "123b4" will now give an "unknown field" error rather than an
    "invalid numeric literal" error.

(All) #1112
    When converting from a non-time field to an HMS field, the conversion
    would not be correct if the input field were longer than 8 characters,
    or the hours value was larger than 99, regardless of the length of
    the destination field.

(SCO OSR5)
    Add a new variable, PFRENEWTIMEOUT=nnn, to control the license renew
    message timeout on SCO OSR5.  The value "nnn" is the number of seconds
    between renewal messages, and can be any number from 2 to 600.  The
    default is 60.
    Note that this variable is unnecessary, and ignored, on other platforms.
    Connectivity issues on OSR5 (cabling, router, TCP/IP stack, network
    congestion) can cause unexpected delays in OSR5 filePro programs (some
    long enough to seem like program hangs). Reducing the value of the
    license renew timeout messages can reduce and even eliminate these
    delays.

(*nix)
    The following environment variables will be set within filePro if the
    license server is not being used:
    PFPID - the process id of the filePro program.
    PFSID - the session id of the filePro program.
    PFLICENSESUSED - the number of licenses that filePro shows to be
        currently in use.
    PFPROCESSCOUNT - the number of license-counted programs that filePro
        shows to be currently running this may be higher than the number
        of licenses used since multiple sessions with the same session
        id will only use one license count.

(Windows) #1114
        fP-SQL would crash when opening an ODBC alien file.

(All) #1115
        fPcopy would crash on a very long filename.

(Windows) #1116
    If the code:
         handle = new odbc_connection(dsn) failed due to a license 
         failure, "handle" would remain unchanged. The typical symptom 
         would be seen as "odbc_conection returned a blank value".