Clarion Community Help

/— Clarion 10.11834 'Gold release' — June 5, 2015 —– Fixes/Changes/Features–/

DOCUMENTATION: Update the documentation on PROP:SQL to describe when to use PROP:SQL and when to use PROP:SQLRowSet

FIX: 'Edit Redirection file' would always load the current Clarion 10 version of the RED file, not the Clarion version you selected.
FIX: The Select Key and Select Column Template Dialogs used the wrong prefix when selecting from an Alias
FIX: You would get errors returned if you accessed an MSSQL server and added or retrieved data from a datetime, time(0), time(1), datetime2(0), datetime2(1), datetime2(2) or datetime2(3) column and had that field declared as a TIME field outside a datetime GROUP structure

PTSS 41633: Lookup button does not work when using an ALIAS file 
PTSS 41642: Error saving a TIME field in a SQL Datetime Field 

REGRESSION: If you had an MSSQL file and you used the BUFFER statement and your file definition had a Clarion TIME field mapped to a DATETIME column, then the wrong data was sometimes returned in the TIME field

/— Clarion 10.11822 beta 10 — May 20, 2015 —– Fixes/Changes/Features–/

CHANGE: Added support to only allow running one instance of an APP (EXE) in Terminal Server or Remote Desktop environment 
CHANGE: DatabaseDrivers.pdf: Update the documentation for the /ZERODATE driver string to clarify that it is used when storing data and when generating WHERE clauses and to document the /ZERODATE=yyyymmdd form of the driver string
CHANGE: Re-organize code in the EnhancedFocusClassType 
FIX: ADD() would sometimes fail if you had AUTOINCUSESSCOPEIDENTITY specified in the driver string
FIX: If a field = file{property}, field = key{property}, field = blob{property}, POSITION(file), POSITION(key), NAME(file), SEND(file) or GETNULLS(file) caused a GPF, then instead of the GPF details being reported in FILEERROR(), the string stack would throw a stack exception
NEW: ABC Templates: New option to enable/disable EIP at run time
NEW: Added support to the internal generated manifest for Windows 10
PTSS 41609: CW10 move to MSSQL DateTime2 breaks TIME field use 
PTSS 41615: Getting Error: String Data, right truncation (22001) on insert 
PTSS 41620: Different Behaviour C9.1 to C10 PROP:SQL with /TURBOSQL=TRUE
REGRESSION: The MSSQL and ODBC drivers did not allow you to add time data to a table if the column was declared as type DATETIME on the MS SQL server and as a TIME field (not within a timestamp GROUP structure) in the Clarion file. 
REGRESSION: File[PROP:HSTMT} would sometimes not return the last used hstmt rather a different one

/— Clarion 10.11787 beta 9 — April 30, 2015 —– Fixes/Changes/Features–/

CHANGE: Add more information when a file not found message shows in the IDE
CHANGE: Property Pad, save and restore last used label column size
FIX: Dictionary Search Result was not using the IDE Defined fonts for list
FIX: FileNotFound Error when trying to register the serial number in a new installation
FIX: Global setting was not being used for the Application Pad fonts
FIX: Initial setup of the "root" macro could fail causing redirection failures
FIX: Property Pad, Stop reseting the size of the pad after the pad is hidden
FIX: Start Page: Clicking on a folder link could open an EXE if there is an exe with the same name in a parent directory

/— Clarion 10.11777 beta 8 — April 22, 2015 —– Fixes/Changes/Features–/

CHANGE: Safer way to store the ClarionProperties xml file. Note: Now a ClarionProperties.old file is stored with the previous properties configuration so in the case of any problem the user can recover settings from the .old file
FIX: Build Solution would not build all projects if there were multiple projects that did not have a project dependent upon them
FIX: Clear Solution did not work
FIX: If you attempted to open a file from the file dialog and a different file with the same name could be found via the redirection system, then the IDE would open the file found via the redirection system rather than the selected file
FIX: PTSS 39916: IDE Docking Drop zones fail to appear on non-primary monitors
FIX: Project options strings were overlapping on the screen for the project properties
FIX: Toolbar control size not set correctly in the options dialog
PTSS 39916: Docking Dropzones fail to appear on non-primary monitors 
PTSS 41500: Project dependencies broken in C10 

/— Clarion 10.11756 beta 7 —- Fixes/Changes/Features–/

CHANGE: Clarion.exe uses an external manifest with setting to run 'asInvoker'
CHANGE: WorkingTemplate: added support for declaring thread safe variables
CHANGE: Added new property to the ABC FileManager "DoNotAssertOnCloseMisuse", the user can set this to True to avoid showing the ASSERTs that show (in debug mode) when a file was not closed with the FileManager method.
FEATURE: Added text to indicate the current sort order to the bottom text box in the Applications Pad
FEATURE: Applications Pad: Added display of date and time to show when the application list is sorted by modification date
FEATURE: New option to always show the modification date and time in the Applications Pad (for all sort orders). If set to false it is only shown when Sorted by modification date
FIX: Applications Pad, the Sort button was not showing the correct icon and text when sorting by dependency
FIX: EXISTS() could return an incorrect result for names of drives' root directories and virtual directories (e.g. "My Pictures")
FIX: REMOVE() when a directory is specified and the second (options) parameter is not provided, it should not remove a directory if it is not empty
FIX: Redirection system was used by File-Open even when the selected file had a full path
FIX: ReportWriter: DLL versions were out of sync
FIX: The ToolbarsizeIcons Dialog was showing the resize but not actually allowing a resize
FIX: When the Applications Pad was empty the descriptive text was not cleared from the text box
PTSS 41329: EXISTS('C:\') fails unless elevated to Admin or Manifest on Virtualized folder 
PTSS 41420: Remove(Folder) should NOT delete all files unless Remove(Folder & ‘\*.*’, REMOVE:FILESONLY) 

/— Clarion 10.11726 beta 6 —- Fixes/Changes/Features–/

FIX REGRESSION: When linking in LIB mode you received linker errors of duplicate symbols when linking multiple file drivers into a program
FIX: Typo in PDF Template

/— Clarion 10.11719 beta 5 —- Fixes/Changes/Features–/

CHANGE: Change the QuickAppConnect class to only show the embeds needed in the embed tree
CHANGE: Invoking editors for objects in read-only APPs
CHANGE: Json class now supports Null as a String value, empty strings will be converted to the 'null' keyword, the setting SetSupportNullString(true) and the column must have the special "picture" of '@NULL'
CHANGE: Updated QuickChat (sockets) example to use the Template instead of hand code.
CHANGE: the menu editor toolbar was not using the color theme Selected
PTSS 41472:  PUT did not work if you did SETNULL(autoIncField); file{PROP:ServerAutoInc}; ADD(file);change fields;PUT(file)
FIX REGRESSION: The Dictionary editor would sometimes throw an exception if you tried to edit properties
FIX: COPY statement could fail for Clarion .DAT files
FIX: JSON code now auto-LINKs the DOS driver when used
FIX: Possible exception at compile time if FILE's driver string or value of the OWNER attribute is unknown identifier
FIX: The Clarion driver would generate an error if an index file was missing when COPY(file) was called
FIX: The context menu in the template source editor did not work if you had a word highlighted
FEATURE: Add the OpenViaRedirectionFile Dialog to the open button quick list in the toolbar
FEATURE: Added option to call the regular File Open Dialog or the Redirection File Open Dialog based on the IDE option setting
FEATURE: Added Record size in bytes to the Table Statistics
FEATURE: Template(s) to use the QuickAppConnectClass (Socket communications)
FEATURE: The OpenViaRedirectionFile Dialog now suggest possible file names found in the redirection system

/— Clarion 10.11643 beta 4 —- Fixes/Changes/Features–/

CHANGE: Appgen now re-uses the dialogs from the DataDictionaryDesign assembly to select Tables, Columns, Keys, and KeyComponents
CHANGE: Remove STD(STD:Close) from ?Ok buttons
CHANGE: specify a FONT for default windows (was missing on some windows)
FIX: DEFORMAT with omitted second parameter could return an empty string if destination string's size was greater than 255
PTSS 41102: DEFORMAT() description should include size limit note, max picture size is 255
PTSS 41404: DEFORMAT(S) fails with 256 byte string, Regression from 5.5 
PTSS 41419: Updated DEFAULTS.CLW files 

/— Clarion 10.11632 beta 3 — Fixes/Changes/Features–/

FEATURE: Compiler: new scanner for the Clarion (CLW) compiler, optimizations
FEATURE: Compiler: support of nested OMIT/COMPILE blocks
FEATURE: Language extensions templates for Sending Emails, Emailing Reports, and Sending SMS (Text) messages
FEATURE: Web Requests (PUT, GET, POST, DELETE) via HTTP/HTTPS
FEATURE: TCP Networking - Client/Server communications: QuickAppConnectClass and methods
FEATURE: Amazon Simple Storage Service (Amazon S3) cloud file access/distribution
FEATURE: WorkingThreadManager Class
FEATURE: Dictionary Global Search and Replace
FEATURE: Project system: Support for the - #file copy srcfile dstfile - command
FEATURE: App options: You can now choose to have the %FILE Template symbol return files in the same order that they are displayed in the dictionary editor
FEATURE: App options: You can now set how many times generator tries to gain access to a file in the Application Options window
FEATURE: ClarionCL: You can now trace the location of a file and the folders search order used by the redirection system from ClarionCL using the /rt switch.
FEATURE: MSSQL driver: Support to use SCOPE_IDENTITY 
FEATURE: Template Registry: The Clarion 10 Application Generator now supports product version identifiers in the naming convention for the TemplateRegistry.trf file.  For example, Clarion 10 by default uses the name TemplateRegistry10.trf.
FEATURE: Exception Log viewer for analyzing crash logs
FEATURE: DCT Statistics displays information about entity statistics (number of fields, keys,etc.) in the in the Comments Tab->Audit information 
FEATURE: Sort by last modified date in the Application Pad
FEATURE: Added Clear Search Result to the Search Result Pad
FEATURE: TCP Sockets class: Added option to send a group (like a RECORD) to another connected client
FEATURE: Added option to the context menu in the Embed Editor and Embeditor to insert color, guid, templates, and open via redirection file
FEATURE: Appearance Options: the Toolbars Icons sizes can be set by the user
FEATURE: Editor: Setting to enable/disable the message on the search when EOF is reached (Tools-Options-Text Editor-General) "continue search at end of file"
FEATURE: Editor: When the search reaches the end of file a message is displayed asking whether to continue from the top of the file
FEATURE: Extension template to use the WorkingThread Class
FEATURE: F1 Help call from Designers now call the help for the selected control property if the Property Pad has focus.
FEATURE: Find All now runs in the background allowing you to do other things while the search is continuing.
FEATURE: If you load an exception log into the IDE it now parses the log file matching up the call stack with the map files and presenting you with a graphical view of the exception where you can double click on a line in the call stack and have the appropriate line loaded into the editor.  Also you can easily switch from hex, to decimal, to text views of the stack dump.
FEATURE: ImageToPNG now support passing the resolution value to make the conversion
FEATURE: JSON: Added method to hide all the field in a group to make it easier when there are more field to hide than to unhide
FEATURE: JSON: Added method to remove the prefix from the fields
FEATURE: JSON: Added property and method to create an ObjectsArray from the Json Object
FEATURE: JSON: Added support for passing String data types by value 
FEATURE: JSON: added new methods ToFile (export into a physical file) and FromFile (import from a physical file)
FEATURE: JSON: added option to add external names for fields
FEATURE: JSON: added methods to Hide/Unhide groups fields, the hidden field will not show in the resulting Json String when a group or queue are converted to Json
FEATURE: New built-in function MAXSTRING to set string variables to max value in accordance with current codepage/locale or collation sequence settings. MAXSTRING is more preferable than CLEAR(s,1) to set files' string fields to initialize key fields before SET(key) and SET(key,key) statements followed by PREVIOUS.
FEATURE: Open via Redirection File added to the template code editor context menu
FEATURE: Optimized handling of passing a picture to some functions
FEATURE: PDF ReportOutput support setting the output resolution when the ScanCopy mode is selected
FEATURE: Templates: Embed point after total a column in a browse list
FEATURE: The Tab Order Assistant can be opened now from the Designer Toolbar
FEATURE: Tool Item in the Tool menu now can have a separator item being added before the item itself
FEATURE: When the Application Editor is closed the the Application Pad is refreshed
FEATURE: XMLQuickParser: added new method to parse XML into a queue and to show the parsed file in a quick window
FEATURE: Xlog Viewer, the IDE can open and display .xlog files
IMPROVEMENT: Faster FORMAT for @D and @T pictures

CHANGE: Add more information to the warning when the project find a problem in merging projects
CHANGE: Add support for run-time checking logs to the Exception Log viewer
CHANGE: Add support for run-time checking logs to the exception log viewer
CHANGE: Added new EQUATEs for additional report paper formats
CHANGE: All the Designers Options are shown under a common node in the options dialog
CHANGE: Amazon: The S3 interface now allows you to query the interface to get the name of the file being transferred in asynchronous mode
CHANGE: AppGen: Procedure selected colors
CHANGE: Better output in the TopScan File Layout window
CHANGE: Cope with NULL pointers passed to some string functions
CHANGE: Dictionary Dialogs now store the position in the same place as the other dialogs. ClarionProperties.xml  - "WindowPositions"
CHANGE: Extend RUN statement by treating the second parameter as a set of flags: flag 01h - wait for launched process termination if set, flag 02h - force usage of ShellExecute to launch process or execute a document
CHANGE: Faster drawing of stretched images that have an alpha channel
CHANGE: If the SQLite dll is missing and tracing is enabled, this error is now written to the log
CHANGE: If you try to synchronise with an SQLite database and the IDE cannot find the SQLite dll, then a more informative error message is now presented.
CHANGE: Import/Export moved to the Clarion node in the options dialog
CHANGE: Legalize background color (PROP:COLOR) for IMAGE controls
CHANGE: Now the Options locator finds the text in the inner properties and selects the Tab where it is found. (i.e. search for OEM)
CHANGE: Selecting the icon for the project now removes the path if the file can be found via redirection
CHANGE: Show more information when an error in the IDE is reported regarding a missing file or missing component file
CHANGE: Show the error when trying to open a file and it has an invalid name
CHANGE: TCP-Sockets: Added method FromJSON to the QuickAppConnectClass as a shortcut to parse the message received when a GROUP is sent
CHANGE: Template version changed to 10
CHANGE: The reason why a recompile is happening is now reported in the output tab
CHANGE: The redirection system used by the IDE now caches locations thus making it much faster to find files the second time
CHANGE: TopScan: Support enhanced encryption for TPS files
CHANGE: Updated Libmaker example, added copy to clipboard option
CHANGE: Updated the text on the settings to reflect that the setting now affects Read Only Projects and Solution
CHANGE: When a message is displayed from Appgen now it allows you to copy the message text (Ie: Exceptions, errors, etc.)
CHANGE: You can now cancel a Find All, Bookmark All or Replace All request

FIX: Mass Update operation in TopScan only modified every 10th record 
FIX: Message box invoked by TopScan on an error opening a table did not show the error text
FIX: TopScan: Avoid flicker on opening a table
FIX: DCT Audit information was not refreshing when different files were selected
FIX: The Clarion template chain was generating REGET(file,position) rather than REGET(primary_key, position) if the file had a primary key
FIX: "Go to base" context menu in editor was not always working. Now when there is a type it shows "Go To Definition" then loads the file if needed
FIX: ABC/Clarion Template: lEmailErrorText was never declared(was included in the wrong declaration group)
FIX: AppGen: Possible exception during code generation
FIX: BUFFER;SET;NEXT;PUT would fail with ODBC based drivers if the primary key components where DECIMAL or PDECIMAL fields
FIX: Buttons in the template LIST control now show with the same height as the Up/Down buttons
FIX: Changing the number of recent files to display was not refreshing till the IDE was closed and reopened
FIX: ClarionCl did not display the possible arguments if you ran it with no parameters before registering Clarion
FIX: ClarionCl did not work if you did not specify a path for /ConfigDir switch.
FIX: Compiler: The parsing tree could become broken on the compilation with debug info of Clarion functions with parameters of CONST *CSTRING or CONST *PSTRING types
FIX: DCT Audit information was not refreshing when different files were selected
FIX: Dictionary Search and Replace was failing when replacing data types
FIX: Dockable toolbox became hidden after undocking
FIX: Docked dockable toolbox could not be dragged
FIX: Doing RESET;NEXT with an SQL file would sometimes retrieve the wrong record if you where resetting on a non-unique key
FIX: Doing a Find All would lock up the IDE with no indication that anything was happening until the find was finished
FIX: Editing the Toolbar icon size was mixing some saved values
FIX: Editor: FindAll calls were made in a non-UI thread to be asynchronous
FIX: Editor: exception could happen if Find next is used with directory search
FIX: Exception Lgviewer: some text was partially clipped
FIX: F1 Help call from Window Designer was not working
FIX: F1 from editor was not working for the selected word
FIX: FORMAT could return incorrect result for @T pictures
FIX: Import an SQL table with very short (1 or 2 character) column names could cause the IDE to crash
FIX: Incorrect comment for the BOX's border color property in the WINDOW/REPORT designers
FIX: Insert PInvoke context menu was showing in text editors context menu were it does not belong
FIX: JSON Empty strings could create an error when calling the EscapeString methods
FIX: JSON class was not correctly parsing arrays with mixed items and nested objects
FIX: JSON was using a local variable instead of parameter. There was not a way to differentiate a decimal from an int
FIX: JSON: String was not clean before re-using it
FIX: LoadAndSave option panel was not showing the full text for the "Use last Directory"  setting option
FIX: Memory leaks in AppGen
FIX: Notification Center was not displaying fixed size with centered text
FIX: JSON: a queue with just one column generates an array of values instead of pairs
FIX: PDF output: Invalid index used in some font metrics
FIX: Possible decimal stack error if incorrect picture is passed 
FIX: Possible exception on opening a multi-table file in TopScan
FIX: REPEAT and DELAY parameters for push buttons could fail
FIX: IDE registration could fail if user changed the default regional settings on window
FIX: Retrieving TIME(n) data into a TIME field that is not part of a time stamp structure would loose sub-second information
FIX: Saving a ReadOnly solution was showing a message even when the setting was to not show the message.
FIX: Some Pads were not using the specified toolbar icons size
FIX: Status Bar position where the Line and Column was displayed sometimes was truncated
FIX: The Exception Log Viewer was not unloading map and log files
FIX: The application icon was not displayed when you entered the project options dialog
FIX: The record picture of a field was not imported into the dct when importing from an MSSQL database