PROP:SQL parses the passed SQL and only sets things up for a return result if the SQL is a CALL or SELECT statement.  It cannot always assume a result set as some backends (MSSQL in particular) do not work if you call UPDATE using calls that normally return a result set.  PROP:SQLRowSet offloads the work of which type of calls to use to the developer.  This allows calls that are not CALL or SELECT that return result sets (eg PRAGMA statement in SQLite), to work.

So we could write code like this:

SQLiteFile{PROP:SQLRowSet}=’PRAGMA table_list’ ! get the list of tables in the database
LOOP
NEXT(SQLiteFile)
…
END

or if using MSSQL

MSSQLfile{PROP:SQLRowSet} = ‘WITH q AS (SELECT COUNT(*) FROM f) SELECT * FROM q’
LOOP
NEXT(MSSQLfile)
…
END

C9 adds a new SYSTEM property; PROP:LowResourcesHook, used to hook handling of post-processing of low system resources.

The redirection system now supports the built-in macro %libpath% in the Copy section of a redirection file.  This macro evaluates to the directory where the .lib file is located when copying the matching .dll to the destination folder. The C9 default redirection file now includes the folder %libpath%\bin\%configuration% in the Copy section.  This matches the structure used by Clarion.NET when you create a .lib file for a .NET assembly, thus making it very easy to add .NET assembly projects to your win32 solution.

New in C9 for reporting;

– Added Single File support to the HTML Report output generator
– ABC Reports: added an option to set the value used for page numbering the first page of the report
– ABC Report Preview: Added “Print Current Page” menu item to the previewer to print just the current page
– Added “Scan Copy” output mode for the PDF Report Generator

Just an example of how you can customize your IDE – this is the Start Page using the “OfficeBlack” theme with the Font set to Tahoma 18pt

In C9 you can now set the Font to whatever you like (including the size) for all Application Generator dialogs (including the template dialogs)

New option in the drop list to limit the Search to the “Current” folder (that would be the same folder as the open active file, typically your project folder but not always)

C9 adds new support for coloring the LIST Control’s column headers and the column data area. You get there from the Extended Options tab. First turn on the “Enable Sort Header” checkbox, and then press the “Customize BowseBox Sort Header” button. Doing so will get you to this template dialog where you can set options as desired for coloring the both the Header and the Column area, with optional color variations for ascending versus descending sorts, so your users can easily visualize the sort order.