Tag Archives: Clarion 12

Clarion Unicode – beta refresh (14407)

Clarion · Unicode Preview · Beta Refresh

Refresh build 14407 — compose any date-time picture, the Embed Editor keeps your language, Known Folders in the templates, and a driver trace that reads true

The @C picture now composes a date picture and a time picture of your choice — @C3D010-T04~T~ is an ISO 8601 stamp with milliseconds, @CD12T05~~ a compact file-name stamp — and FORMAT, DEFORMAT, ENTRY controls, the designers and the Source Editor all take the composed form. The Embed Editor keeps a Greek, Cyrillic, Chinese or emoji literal exactly as you typed it, in the .app and on screen. The Global Properties folder lists offer the Windows Known Folders beside the CSIDL values, and the data path is a USTRING. The driver trace file is UTF-8, so every Unicode value in a record dump or a bind line reads as typed. The frame’s Window menu and MDI tab bar, STOP and HALT, TopScan’s Text and Hex Viewers and the Query Center’s DATETIME filter are wide. Already testing? Everything below is new since build 14373.

Language @C[n][D…][T…][~sep~] composed date-time pictures IDE Embed Editor keeps U'' literals · TopScan Text / Hex Viewer wide · Window menu + tab bar wide Templates Known Folders in Global Properties · PROP:DataPath USTRING · QBE DATETIME filter SQL the driver trace file is UTF-8 From the forums STOP() / HALT() wide · ADO MapRsToGroup · @C in the QBE filter · wide captions in the Window list · ??? in the trace · USE(Var,,?Var2) in the designer · FROM(U'...') in the help

Highlights of this drop — then the full tester guide, whose “What’s new” section lists everything that changed since you last read it.

@

The date-time picture takes any date and time format

@C[n][S][D…][T…][B]: n keeps its meaning (0–7 fraction digits), S is one separator character between the two parts (_ for a space, ^ for none, T for ISO 8601, any other character stands for itself), and the two parts are any numbered @D and @T picture with all of their own options. Omitted parts keep today’s shape, so @C, @C3 and @C7 are unchanged. @C3D010-T04~T~ gives 2026-09-09T13:05:07.123, @CD12T05~~ gives 20260909130507, @CD8T4 gives 9 SEP 2026 13:05:07. FORMAT, DEFORMAT, STRING and ENTRY controls and the USTRING lane take the composed form; the Window and Report Designers accept it in the Picture property and draw it on the canvas, and the Source Editor colours the whole picture. The Help topic “Date-Time Pictures” has the full table. From a request on the beta forum.

U’

The Embed Editor keeps your language

Type Greek, Cyrillic, Chinese or emoji inside a '...' literal in any embed and save: the literal is stored in the .app as its portable U'...' form, the same thing the Window and Report Designers do for a caption, and when you open the embed again the editor shows your letters — U'Привет'. The running window shows the text. The unit is one literal, judged against your Windows ANSI code page: a literal the code page holds is saved byte-identical, so existing embeds do not change; only string literals are converted, a comment goes through the code page as before. The How-do-I topic “How do I put Greek, Russian, Chinese or other Unicode text into an embed?” leads with “type it” and keeps the UTF-8 INCLUDE file and the spelled code points as alternatives. From a beta report.

⌂

Known Folders in the templates, a USTRING data path

The two Global Properties dialogs that placed your INI file and your data files in a CSIDL location (App Settings › “Location of Program Name.INI”, File Control › File Access Data Path) now list the Known Folders in the same drop list: Documents, Public Documents, Roaming AppData, Local AppData, ProgramData, User Profile and Downloads. Pick one and the generated program resolves it through the Known Folder API as a USTRING, keeps the INI file name wide (INIClass.InitW), creates the Company\Product sub-folders wide (SpecialFolder.CreateKnownDirIn) and sets SYSTEM{PROP:DataPath} from the USTRING, so a user whose profile folder carries characters outside the ANSI code page gets the exact path. Both chains; an application on a CSIDL value generates exactly what it did.

≡

The driver trace file is UTF-8 — every value reads as you typed it

A USTRING field in the record dump (PROP:Details) and a Unicode bind value on the SQL trace line show their Greek, CJK, Arabic or emoji characters as they are, on SQL Server, PostgreSQL and the other ODBC backends, Oracle and SQLite alike; an accented letter in a plain STRING reads as text too. A new trace file starts with the UTF-8 byte-order mark, so Notepad, the IDE and VS Code open it correctly — delete a trace written by an earlier build before you start a new one. The DEBUG: target shows the same characters in the debugger’s output window. From a beta report of ??? in the trace for Arabic text: fixed now.

▤

Query Center: a DATETIME column in the QBE Filter – Advanced list

A column whose picture is @C (any number of decimals) is a date-time to the filter: every operator takes what the picture displays, a date alone included, and the generated filter uses the column’s own picture — on a SQL backend the ISO literal, on Oracle its TO_CHAR text. Existing date, time, number and string columns generate exactly what they did, with one exception you will like: a SQL date IN list typed with a space after the comma carries both dates. A date-time entry accepts the time to the minute (2026-09-26 10:30) everywhere @C deformats. Everything in the shipping templates and classes that decides “is this picture a date?” tests @C before @D; if your own code classifies by the second character, give it a @C arm first. From a beta report.

▣

Wide in the frame: the Window menu, the MDI tab bar, STOP() and HALT()

A child window with a Unicode caption is listed by that caption in the frame’s Window menu (STD:WindowList) and on the MDI tab bar — set it at run time (0{PROP:Text} = U'...') or declare a U'' title, the title bar, the list and the tab show the same text in any script. STOP() and HALT() show a USTRING message exactly, the way MESSAGE() already does. A tip that came with the same report: in a source file saved as UTF-8 a plain '...' literal is still an ANSI string, so write the text as a U'...' literal and the USTRING holds it exactly. Both from beta reports: fixed now.

16

TopScan: the Text Viewer and the Hex Viewer show a USTRING column in full

Pick a USTRING column in either tool (View › Show Text, View › Show Hex): the Text Viewer shows and edits the text in any script, emoji included, and the Hex Viewer shows the value’s UTF-16 bytes as stored, two per character unit, with a new UTF-16 character pane beside the bytes — one cell per unit, read live from the bytes, an emoji in one cell; click a character and the cursor lands on its first byte, ready for a byte edit. Save in either tool stores exactly what you see. A BLOB,UNICODE column reads the same way; STRING and every other column type look and save as before.

✎

From a beta report: ADO recordsets into your group

TableMapper.MapRsToGroup assigns each recordset column through an ANY bound with WHAT() to the group field — the statement every ADO browse and form runs per column. It holds for every VARIANT type the recordset returns: integers, booleans, doubles, strings; a double into an integer field keeps its whole part, as build 14000 did and as a direct LONG = VARIANT does. Fixed now.

?

From a beta report: the Window Designer keeps USE(Var,,?Var2)

An explicit field equate that is the variable name plus a digit suffix (?PagesAcross2, ?Cnt10, also with the number parameter present: USE(Var,3,?Var3)) came back as USE(Var) once the designer had opened the window, and the compile then reported duplicate equates. The designer keeps it now; USE(Var,,?Var) still comes back as USE(Var), the same equate. And from a question on the beta forum: the FROM help topic now says how a drop list goes wide — FROM(U'...'), one U in front of the whole string, U on every piece of a constant continued with &, a USTRING through {PROP:From} at run time — with index entries under FROM, Unicode, USTRING and “drop list”. Fixed now.

Full tester guide — mental model, conversion rules, DCT import table, screen controls, reports, blobs, SQL / SQLite / text drivers / TopSpeedW / Memory / IP, recipes, the new-language-surface quick reference, and what to focus on when testing. The guide’s “What’s new” section lists everything in this drop, and every section has its task topic in the F1 help’s “How do I …” chapter.

Open the full Unicode Tester Guide

Report tool authors — the wide generator surface (IReportGeneratorW), format detection, the EMF record set, transition paths per integration style, and the PageTextIndexClass text index the previewer searches with:

EMF Page Files — Transition Note

Standalone pages (best full-width). Everything described there is implemented unless marked as a known limitation — if you see something different, the beta forum is the place.

Clarion Unicode preview — beta refresh build 14373

Clarion · Unicode Preview · Beta Refresh

Refresh build 14373 — lost SQL connections re-establish themselves, SQL browses fetch faster, and the help gains a “How do I” chapter

A SQL drop. Lost server connections now automatically re-establish the connection to the server and the application continues gracefully: a VPN reconnect, a firewall that closed the session, a laptop that woke up — the files and views stay open, the next operation reconnects, a browse that was paging simply keeps paging. Two new browse prompts fetch a SQL page in one round trip instead of one row per trip, with a BLOB in the page up to 10x faster on SQL Server. A SQL connection configures itself from the OWNER string alone, no DSN on the user’s machine. The IDE’s “select a folder” is the modern Windows folder dialog everywhere. And the F1 help has a “How do I …” chapter with a task topic for every section of the tester guide, every topic in the Index. Plus the fixes and additions from beta testers’ reports in the forums: Known Folders, the wide CLIB twins, a two-picture DateTime format, a friendlier previewer. Already testing? Everything below is new since build 14313.

SQL automatic reconnect · ‘Page fetch size (SQL)’ · ‘BLOB fetch (SQL)’ · PROP:BlobFetch · DSN-less connect IDE the modern select-folder dialog on every “…” Help “How do I …” chapter · every topic indexed · Customizing a SQL Connection Compiler USTRING link names sz / z — rebuild multi-DLL solutions together From the forums Known Folders · CLIB wide twins + RmDirW · Pict(dt, pic1, sep, pic2) · previewer Jump / sidebar · varchar(max) as BLOB · BLOB hot fields · VALUE() / PROP:Value / SPIN FROM wide · PROP:FromQueue · Designer paints <13,10>

Highlights of this drop — then the full tester guide, whose “What’s new” section lists everything that changed since you last read it.

↻

Lost server connections re-establish themselves, the application continues

ODBC, MSSQL, Pervasive SQL and SQL Anywhere drivers. When the link to the server drops under a running program, every file and view of that connection stays open, the failed operation reports error 90 with the driver’s own message (FILEERRORCODE() = 08S01), and the next operation reconnects by itself — including a table the program opens for the first time after the drop, so the first save after an outage goes through. In a generated application (ABC and Clarion chains) the user sees one error box and the usual retry prompt, and Yes saves the record. A browse that was paging when the link went keeps paging: the generated browse re-runs its page fill once, on a fresh connection, and the user sees nothing at all. Hand code simply retries the failed statement; a VIEW continues after a RESET to its last position.

≫

SQL browses fetch a page per round trip — two new prompts

BrowseBox › Actions › Default Behavior, both chains. ‘Page fetch size (SQL)’: a value n fetches n rows per server round trip (ABC sets BRWn.PageSize, the Clarion chain emits BUFFER(view, n, 2, 0, 60)); a Clarion-chain SQL browse moves from one row per trip to n. ‘BLOB fetch (SQL)’ with the new PROP:BlobFetch: a browse that shows a BLOB keeps its page fetch — the driver positions on your row and reads the page in one trip, a 20-row page fill on SQL Server measured 110 us/row down to 11.5. Blank prompts generate exactly what they did, so an existing app changes nothing until you set them. A BLOB projected into a VIEW is the current row’s from the very first read, so a TEXT or IMAGE bound to a browse hot-field BLOB follows the highlight bar.

◫

AppGen: a BLOB can be a browse hot field

Pick a BLOB as a hot field on a BrowseBox and a TEXT or IMAGE bound to it follows the highlight bar: the picture, the note, the document of the selected row. The templates put the BLOB into the browse’s VIEW as a PROJECT and never into the queue (a queue cannot LIKE() a BLOB), and the highlighted row is re-fetched on every selection change, so the control always shows the current row’s blob. Both template chains, no hand code.

⚙

A SQL connection configured from the OWNER string alone

The UNICODECONNECT form works without a DSN on the PostgreSQL Unicode driver and on SQL Server: name the driver DLL and its settings as keywords in the OWNER and nothing is configured on the user’s machine. The new help topic “Customizing a SQL Connection” lays out the three layers — the OWNER string, the driver string switches, the ODBC driver’s own settings — with a copy-ready example for each. Over a slow link to SQL Server, /MULTIPLEACTIVERESULTSETS=TRUE streams the rows instead of a server cursor round trip per fetch block; the guide’s SQL section says when to use it.

▣

The IDE picks folders with the modern dialog

Every “…” in the IDE that asks for a folder — New Project’s Location, the default project location in Options, Find in Files’ Look in, the project option folders — opens the Windows common item dialog in folder mode: the navigation bar, search, the places on the left, a “New folder” button, resizable. The small “Browse For Folder” tree is gone from the IDE. The most reported request of the beta, inside and outside.

⌂

Known Folders: Downloads, Documents, AppData and every other one, by name

SpecialFolder.GetKnownDir(KF:Downloads) returns the user’s Downloads folder, the one the CSIDL list never had. KNOWNFOLDER.EQU declares the common KNOWNFOLDERIDs as KF: equates — Downloads, Documents, Desktop, Pictures, Music, Videos, LocalAppData, RoamingAppData, ProgramData, Profile, Fonts, ProgramFiles, ProgramFilesX86, Startup, the Public ones — and any other folder from KnownFolders.h is one more equate written the same way. GetKnownDir(KF:Documents, 'MyApp') appends your sub-directory, the path comes back as a USTRING so a folder outside the ANSI code page is exact, and GetKnownError() holds the HRESULT of the last call. The CSIDL methods you already use are unchanged.

✚

Wide CLIB twins, a two-picture DateTime, a friendlier Report previewer

CLIB.CLW declares the wide twins FnSplitW, FnMergeW, MkDirW, AccessW and the new RmDirW, so a program that includes CLIB.CLW calls them by name. DateTimeUtil.Pict(dt, '@D10-', 'T', '@T04') joins two pictures with a separator — an ISO stamp, a file-name stamp — in one call. The report previewer’s Jump to a Page shows “of N pages”, clamps a typed number, and has First / Last buttons; the thumbnail sidebar’s scroll buttons sit side by side at the top. And the driver trace now shows a USTRING value in full, in the record dump and on the SQL bind lines, so a trace tells the truth about Unicode data. A browse sorted by a USTRING key on SQL Server positions cleanly from every sort tab, and saving a BLOB with bind tracing on no longer ends in an access-violation box. A wide VALUE() on a CHECK or RADIO lands in the USE variable with its exact units, {PROP:Value} on any captioned control and a SPIN’s wide FROM() deliver exact units too, and CONTENTS(?Combo) answers for a COMBO without a USE variable. And the Window and Report Designers paint <13,10>, every decimal metachar and {n} repeats exactly like the compiled window.

?

F1 help: a “How do I …” chapter, every topic in the Index

Right after Welcome to Clarion in Contents: 22 task topics, one per section of the tester guide (Unicode strings, screens, reports, SQL, TopSpeedW, the lost connection, the faster SQL browse …), each linking to the reference topics it needs. The Index finds them by title and by the words you would type — “lost connection”, “reconnect”, “faster SQL browse”. Every topic in the help now carries its title and chapter as index keywords, the 2026 reference topics carry a “See also” line, and the new browse prompts are documented where F1 on the prompt lands.

✎

From beta testers’ reports: dictionary, AppGen, DATETIME, previewer

varchar(max) imports as a BLOB, so the whole column travels (it joins text, ntext, nvarchar(max) and varbinary(max) under one rule). DateTimeUtil builds from LibSrc alone and gains Pict(dt, picture) — the date part through @D4, the time part through @T4, the whole value through @DT. The Window Previewer’s generated program reads better and compiles every time, with @DT controls primed with a real date-time sample.

ƒ

USTRING link names of their own — rebuild multi-DLL solutions together

USTRING parameters now mangle as sz (every non-RAW form) and z (RAW), a link name no other type can produce, so a *USTRING and a *SHORT,ANY prototype never share one. What to do on this build: regenerate and rebuild every module of a multi-DLL solution together (template-generated .exp files regenerate on their own); a hand-written .exp with zu/su lines changes them to sz; Pro2Exp / Exp2Map users update the letter table.

Full tester guide — mental model, conversion rules, DCT import table, screen controls, reports, blobs, SQL / SQLite / text drivers / TopSpeedW / Memory / IP, recipes, the new-language-surface quick reference, and what to focus on when testing. The guide’s “What’s new” section lists everything in this drop, and every section has its task topic in the F1 help’s “How do I …” chapter.

Open the full Unicode Tester Guide

Report tool authors — the wide generator surface (IReportGeneratorW), format detection, the EMF record set, transition paths per integration style, and the PageTextIndexClass text index the previewer searches with:

EMF Page Files — Transition Note

Standalone pages (best full-width). Everything described there is implemented unless marked as a known limitation — if you see something different, the beta forum is the place.

Clarion Unicode preview — refreshed beta build (14313)

Clarion · Unicode Preview · Beta Refresh

Refresh build 14313 — a modern report previewer, Unicode reports by default, a DATETIME type for SQL, and the wide file-name family complete

A bigger drop. With EMF pages new functionality is within reach, and the first of it is a new report previewer: search with highlighted hits, page thumbnails, marks, print or save the marked pages, copy text off the page — on a wide report all of it Unicode. For this beta release every existing application picks the previewer and Unicode (EMF) reports up automatically from the templates on its next generate, so de facto every app gets EMF reports; a hand-coded program reaches the same with the new compiler pragma define(report_unicode=>on). Tell us how that lands on your reports and your third-party report tools — that default is yours to confirm. A new DATETIME type carries a SQL timestamp to 100 nanoseconds through the compiler, the dictionary, the import wizard and every SQL driver. RUN() and COMMAND() go wide, closing the file-name family. Plus the fixes from beta testers’ reports in the forums. Already testing? Everything below is new since build 14258.

Reports ReportPreviewClass · Unicode reports by default · report_unicode define · PROP:Unicode Data DATETIME type · @DT picture · DateTimeUtil · import wizard checkbox Runtime RUN / COMMAND wide · CLIB wide twins · ALL() negative count IDE IMAGE field picker · no BLOB list columns · property search

Highlights of this drop — then the full tester guide, whose “What’s new” section lists everything that changed since you last read it.

▤

A modern report previewer — reached through EMF pages

ReportPreviewClass: text search across every page with the hits highlighted (Ctrl+F, F3, match case), a thumbnail sidebar, page marks with Print Marked and Save Marked Pages As, Fit Page and Ctrl+plus/minus zoom, Shift+drag to copy the text under the band, layout remembered in the INI, the index built on its own thread so a 1,000-page report opens at once. On a wide report the search is Unicode. It is the default for new apps, and a Print Previewer prompt that still reads PrintPreviewClass generates the new class on the next generate; “Keep the classic PrintPreviewClass previewer” opts out.

☷

For this beta release, reports print Unicode (EMF) by default

The new global “Unicode reports” check (on by default for this beta, so we hear how it lands) makes each Report procedure set Report{PROP:Unicode} = True as its report opens — USTRING fields, wide captions and emoji print as typed on .emf pages, error 546 stops, the PDF/HTML/TXT targets register their wide face; a per-procedure “Unicode pages” prompt opts one report out. The same check writes the compiler’s report_unicode define into the project, so hand-coded REPORT structures carry the UNICODE attribute too (PRAGMA('define(report_unicode=>on)') in a hand-coded module). PROP:Unicode is documented as the run-time face of the attribute. Watch for: a third-party page tool that read .wmf files sees .emf now.

⌚

DATETIME: a date and a time in one value, to 100 ns

A new data type — seconds since the Clarion day zero with seven decimal places, the precision of SQL Server’s datetime2(7). Compares, sorts, keys and does arithmetic in seconds; zero is blank. In a SQL table it reads and writes the backend’s timestamp column and CREATE() declares it: datetime2(7), timestamp(6), SQLite ISO text, Oracle TIMESTAMP(7); a VIEW filter on it is evaluated server-side. The @DT…@DT7 picture formats and enters it, DateTimeUtil converts to and from DATE and TIME (SetNow reads the precise clock), the Dictionary Editor offers the type, and the SQL import wizards create it for timestamp columns when “Import date-time columns as DATETIME” is checked (off by default — nothing changes for existing dictionaries).

▶

RUN() and COMMAND() wide — the file-name family is complete

RUN() takes a USTRING command line: a program in a folder outside the Windows codepage is located and started exactly and its parameters travel as typed; an ANSI-only USTRING takes the old path byte-for-byte. COMMAND() no longer shifts every parameter by one for a program that lives in such a folder (the ₿ folders from the forum). CLIB.CLW stays narrow by design, with four exported wide twins (_fnsplitW, _fnmergeW, _mkdirW, _accessW). With EXISTS, COPY/RENAME/REMOVE, DIRECTORY, FILEDIALOG and the PATH family already wide, that closes the family.

✎

Designers and dictionary, from beta testers’ reports

The Window Designer’s IMAGE gets the dictionary-field picker (BLOB and BINARY MEMO fields, the ones IMAGE,USE() accepts), and dropping a BLOB onto a window creates an IMAGE bound to it. A BLOB is never offered as a list-box column, and an app that already has one stops generation with a plain sentence instead of the compiler’s “Illegal parameter for LIKE”. The property-pane search is case-insensitive in every designer, and UNICODE is coloured as an attribute in the editor.

ƒ

Fixes from the forums: ALL(), the PDF class, datetime2 DDL

ALL() with a negative count returns ” again instead of “Clarion RTL internal exception” 0B000000. ABPRPDF.CLW compiles without warnings, and a real defect went with them: a wide report text longer than 99 units was cut in the PDF (150 units drew as 15). MS SQL CREATE of the legacy datetime group emits datetime2(7) on SQL Server 2008 and later — “Specified scale 8 is invalid” is gone.

?

F1 help, current for this drop

The IDE help (ClarionHelp.chm) carries new topics for DATETIME, the Date-Time Pictures, ReportPreviewClass, PageTextIndexClass and the Report template’s Preview Options; PROP:Unicode and the report_unicode define on the REPORT pages; the “Unicode reports” and “Unicode pages” prompts; and the three new stock icons ICON:PageUp, ICON:PageDown and ICON:Clear.

Full tester guide — mental model, conversion rules, DCT import table, screen controls, reports, blobs, SQL / SQLite / text drivers / TopSpeedW / Memory / IP, recipes, and what to focus on when testing. The guide’s “What’s new” section lists everything in this drop; changes are also flagged inline with dated “beta refresh” notes.

Open the full Unicode Tester Guide

Report tool authors — the wide generator surface (IReportGeneratorW), format detection, the EMF record set, transition paths per integration style, and now the PageTextIndexClass text index the new previewer searches with, usable by your own viewer as-is:

EMF Page Files — Transition Note

Standalone pages (best full-width). Everything described there is implemented unless marked as a known limitation — if you see something different, tell us on the beta forum.

Clarion Unicode preview — refreshed beta build (14258)

Clarion · Unicode Preview · Beta Refresh

Refresh build 14258 — the designers keep your Unicode, the fixes from four beta threads, and the wide path family

A shorter drop, built from the beta forum. The Window and Report Designers accept every U'' spelling and no longer rewrite it into a raw glyph; the Window Previewer can keep the generated program; DROP lists and COMBOs take a wide FROM at runtime; INSTRING() searches backwards from past the end; FILEDIALOG() opens on a Unicode folder; and the porting notes for SIZE() are in the help. Threads 47, 54, 57 and 60, closed. Already testing? Everything below is new since build 14234.

IDE U” hex literals in the designers · ANSI files keep U” · Save Preview Program Runtime DROP/COMBO wide FROM · INSTRING · FILEDIALOG Help SIZE() porting notes · INSTRING start rule

Highlights of this drop — then the full tester guide, whose “What’s new” section and dated “beta refresh” markers flag exactly what changed since you last read it.

✎

Designers: every U” spelling works, and your Unicode stays Unicode

The Window and Report Designer parse U'<26DDh>', U'<1F600h>' and {n} repeats exactly like the compiler — build 14234 refused a window with a hex literal. And a designer opened from an ANSI .clw now writes wide text back as a U'' literal (decimal units) instead of a raw glyph that forced the save-as-UTF-8 prompt; UTF-8 sources keep the glyph as before.

☷

DROP lists and COMBOs: a runtime wide FROM

?List{PROP:From} = U'…' on a LIST,DROP() or a COMBO keeps its characters — in 14234 that one property took the narrow path, so a declared FROM(U'…') worked and the runtime write showed ?. Reminder for continued FROM strings: put U on every piece.

ƒ

INSTRING backwards from past the end, and two porting notes

INSTRING(sub, s, -1, SIZE(s)) now finds the last match on a CSTRING or USTRING (those push only their used length, so a start past the end returned 0). Porting notes in the help: SIZE() of a USTRING is bytes, so a Windows API’s character count is SIZE(v)/SIZE(v[1]) — right for every string type — never SIZE(v).

▭

Window Previewer: Save Preview Program

A second checkable item in the Window menu, under Unicode Preview: latched on, the generated preview program, its project and exe move into .WinPreview\ in the project folder with the injection include beside them, so File ▸ Open builds and runs it as-is; a preview that fails to compile still keeps its source. Both latches are menu items only — the toolbar keeps just the Preview button.

⌂

FILEDIALOG positioned; the “Internal error 01” dialog is gone

FILEDIALOG() with FILE:Directory and a USTRING start folder opens with the selection on that folder even when its name is outside the Windows codepage. The “Output corrupted stack, wsldebug.cpp line 412” dialog was the release diagnostic logger misfiring; it now logs to C120LOG.TXT and carries on, so what you see next is the real fault.

\

PATH, SETPATH, LONGPATH and SHORTPATH are wide

A USTRING folder or file name is resolved in its exact characters and the result comes back wide, so a folder whose name lies outside the Windows codepage can be entered with SETPATH and read back with PATH() (the earlier drop best-fit it to ? and SETPATH failed with error 3). The no-argument forms return the current directory exactly; a STRING argument or receiver gets the same bytes as always. With EXISTS, COPY/RENAME/REMOVE, DIRECTORY and FILEDIALOG already wide, only RUN remains in the file-name family.

?

F1 help, current for this drop

The IDE help (ClarionHelp.chm) carries the INSTRING start rule with a SIZE(cstring) example, the USTRING porting note, the previewer’s second latch, and a USTRING note on each of the PATH, SETPATH, LONGPATH and SHORTPATH topics.

Full tester guide — mental model, conversion rules, DCT import table, screen controls, reports, blobs, SQL / SQLite / text drivers / TopSpeedW / Memory / IP, recipes, and what to focus on when testing. The guide’s “What’s new” section lists everything in this drop; changes are also flagged inline with dated “beta refresh” notes.

Open the full Unicode Tester Guide

Report tool authors — the wide generator surface has shipped (IReportGeneratorW — six methods, opt-in, zero break for existing implementors). Format detection, the EMF record set, transition paths per integration style:

EMF Page Files — Transition Note

Standalone pages (best full-width). Everything described there is implemented unless marked as a known limitation — different behavior is exactly what we want to hear about.

Maintenance Release + USTRING Beta (Compiler/RTL Changes)

We have two updates scheduled for release this week:

  • Maintenance Release (shipping first)
  • USTRING Beta Release (follows)

USTRING Beta: Compiler + RTL Changes

The USTRING implementation requires coordinated changes to both the Compiler and RTL (Runtime Library).

We initially explored making the RTL interchangeable at runtime, allowing the IDE to switch between:

  • Shipping (production) RTL
  • USTRING-enabled (beta) RTL

However, this approach introduced unnecessary complexity and risk of cross-contamination between environments.

Decision:
We are shipping the USTRING beta as a separate IDE build, each with its own aligned Compiler + RTL.

Result:

  • Eliminates risk of mixing beta RTL into production builds
  • Keeps production and experimental toolchains fully isolated
  • Simplifies support and debugging

Fix: “Check for Updates” Failure

The Check for Updates feature failed shortly after the C12 release.

Root Cause:

  • A server-side WAF (Web Application Firewall) policy change
  • Requests were rejected with HTTP 403 (Forbidden) during TLS negotiation/connection handling

Status:

  • ✅ Client-side handling updated
  • ✅ Server compatibility restored

The update mechanism is now functioning normally.

Email Notification Rollout

Because the update mechanism is unavailable, we are notifying all subscribers via email.

  • Rollout begins this week
  • Email platform has been changed to improve delivery reliability

If you encounter any issues with updates or the new builds, please report them so we can address them quickly.

Understanding USTRING: A Deep Dive into Clarion 12’s UTF-16 Implementation

This post focuses on practical details and what they mean for your day-to-day development, with an eye toward where we’re headed next.

In our previous article, we announced the USTRING data type was coming back, and its intended role in Clarion 12’s Unicode support. Now, let’s explore the implementation details that will help you work more effectively with the USTRING.

USTRING is UTF-16: What This Means for You

At its core, the USTRING data type uses UTF-16 encoding, allocating two bytes per character. This architectural decision provides several key advantages:

  • Native Windows support: Windows internally uses UTF-16 for all Unicode operations, making USTRING integration seamless
  • Fixed-width benefits: Most common characters (including all Latin, Cyrillic, Greek, and CJK characters in the Basic Multilingual Plane) use exactly 2 bytes, simplifying string indexing
  • Complete Unicode coverage: Through surrogate pairs, UTF-16 can represent every Unicode character
  • Predictable memory usage: Easy calculation of memory requirements
Name     USTRING(21)              ! 21-character Unicode string
Company  USTRING('SoftVelocity')  ! Initialized with a value
Phone    USTRING(@P(###)###-####P) ! Formatted with picture token
MyStr    USTRING(20)              ! 20 characters available

When you declare USTRING(20), you’re reserving space for 20 characters plus a null terminator. Internally, this allocates 42 bytes (21 characters × 2 bytes each).

Memory Layout: USTRING(20)

Declaration:  USTRING(20)
Allocation:   [    40 bytes for 20 characters    ][2 bytes null]
              |<────────── 20 chars × 2 bytes ─────>|
Total Size:   42 bytes

Example with "Hello":
Position:     1    2    3    4    5    6-20  21
Character:    H    e    l    l    o    (empty) \0
Bytes:       [H ][e ][l ][l ][o ][  ...  ][\0]
              2   2   2   2   2      30      2
                                          WCHAR(0)
              <─── 40 bytes for data ────> <2>

Total: 42 bytes allocated (40 for characters + 2 for null terminator)

Important: The null terminator WCHAR(0) occupies 2 bytes because it’s a wide character, just like every other character in the string. This is how functions like lstrlenW know where the string ends—they scan for this 2-byte null value.

Dual Character Set Support: The Best of Both Worlds

One of USTRING’s practical strengths is transparent handling of both Unicode and ANSI content. You can freely mix Unicode literals and ANSI strings in your code:

MYUSTR  USTRING(50)

CODE
  MYUSTR = u'Α Ω'            ! Greek Unicode characters
  MYUSTR = 'Regular Text'    ! ANSI text works too
  MYUSTR = u'Mix: ' & 'Α Ω' ! Concatenate both types

The runtime handles conversions automatically, respecting the current code page settings. When working with international applications, you can set the code page and locale to ensure proper character handling:

SYSTEM {PROP:Codepage} = 1253   ! Greece
SYSTEM {PROP:Locale} = 1032     ! Greece

LEN() vs SIZE(): A Critical Distinction

This is where developers first encounter USTRING’s two-byte nature. The distinction between LEN() and SIZE() directly reflects the UTF-16 implementation:

MYUSTR  USTRING(20)
L       LONG
S       LONG

CODE
  MYUSTR = u'Α Ω'            ! 3 Unicode characters
  L = LEN(MYUSTR)            ! L = 3 (character count)
  S = SIZE(MYUSTR)           ! S = 40 (20 characters × 2 bytes)

LEN() returns the logical length—the number of characters actually stored in the string. This is what you typically care about when processing text.

SIZE() returns the allocated byte capacity. For a USTRING(20), SIZE() always returns 40, regardless of how many characters you’ve stored. This represents the maximum storage available.

Understanding this distinction matters when:

  • Allocating buffers for string operations
  • Interfacing with external APIs that expect byte counts
  • Optimizing memory usage in data structures
  • Working with file I/O operations

How SIZE() Actually Works

For fixed-size declarations like USTRING(20), SIZE() is calculated by the Clarion compiler at compile-time. The compiler knows the capacity is 20 characters and generates code that returns 20 × 2 = 40 directly—no runtime function call needed.

This is why SIZE() is so fast: it’s just a constant value, not a calculation that happens when your code runs.

When LEN() and SIZE() Differ: A Practical Example

UserInput  USTRING(100)      ! Allocated capacity: 100 chars
Bytes      LONG
Chars      LONG

CODE
  UserInput = ''             ! Empty string
  Chars = LEN(UserInput)     ! Chars = 0 (no content)
  Bytes = SIZE(UserInput)    ! Bytes = 200 (capacity still allocated)

  UserInput = u'Hi'          ! Short string
  Chars = LEN(UserInput)     ! Chars = 2 (actual content)
  Bytes = SIZE(UserInput)    ! Bytes = 200 (capacity unchanged)

  ! Key insight: SIZE() never changes after declaration
  ! LEN() reflects actual content

Memory Allocation: Understanding the 2:1 Ratio

When you declare a USTRING, the actual memory allocated is double the character count you specify:

Small   USTRING(10)              ! Allocates 20 bytes (10 × 2)
Medium  USTRING(100)             ! Allocates 200 bytes (100 × 2)
Large   USTRING(1000)            ! Allocates 2000 bytes (1000 × 2)

Right-Sizing Your Strings

Choose appropriate sizes to avoid wasting memory. Here’s what oversizing costs:

! Good - sized appropriately
FirstName  USTRING(50)            ! 100 bytes allocated

! Wasteful - unnecessarily large
UserName   USTRING(500)           ! 1000 bytes allocated
                                  ! If only ~50 chars used: 100 used, 900 wasted

Comment    USTRING(5000)          ! 10,000 bytes allocated
                                  ! If only ~100 chars used: 200 used, 9,800 wasted

When Memory Size Actually Matters

Understanding when to worry about USTRING memory overhead:

! Scenario 1: Single string - overhead is negligible
CustomerName  USTRING(100)     ! 200 bytes total
! Impact: Minimal - 100 extra bytes compared to ANSI

! Scenario 2: Large collections - overhead multiplies
CustomerQueue QUEUE
Name            USTRING(100)   ! 200 bytes
Address         USTRING(200)   ! 400 bytes
City            USTRING(50)    ! 100 bytes
              END

! Impact with 100,000 records in queue:
! USTRING: 70,000,000 bytes (70 MB)
! STRING:  35,000,000 bytes (35 MB)
! Difference: 35 MB - this is where sizing matters!

! Or with an array:
CustomerArray USTRING(100), DIM(100000)  ! 20,000,000 bytes (20 MB)
! vs STRING(100), DIM(100000)            ! 10,000,000 bytes (10 MB)

Rule of thumb: For individual strings, use generous sizes. For large queues, arrays, or tables, size more carefully.

Design-Time vs Runtime Allocation

! Design-time: Fixed size declared in source
MyStr  USTRING(100)          ! 200 bytes allocated at compile time

! Runtime: Dynamic allocation with NEW
MyStr &USTRING               ! Reference to dynamically allocated string
CODE
  MyStr &= NEW USTRING(100)  ! 200 bytes allocated at runtime

Design-time declarations have a maximum size of 4MB, while runtime allocations can be sized dynamically based on your application’s needs.

Working with Unicode Literals

When initializing or assigning to a USTRING, use the U or u prefix for Unicode literals:

MyStr USTRING(50)
CODE
  MyStr = U'Ω α β'     ! Correct - U prefix for Unicode
  MyStr = u'Ω α β'     ! Also correct - lowercase works too
  MyStr = 'Ω α β'      ! Works but may not preserve Unicode properly

Practical Implications for Your Code

Character Access is Read-Only on Assignment

You can read individual characters using slice syntax, but cannot assign to them:

C = MyStr[5]        ! Read character at position 5 - ALLOWED
MyStr[1] = 'A'      ! ERROR - Not allowed, creates invalid string

This restriction maintains string integrity in the UTF-16 implementation.

Use LEN() for Logic, SIZE() for Memory

! Correct usage
IF LEN(UserInput) > 0            ! Check if string has content
  ! Process input
END

! Memory allocation calculation
BytesNeeded = SIZE(MyStr)        ! Get total allocated bytes

Current Limitations

The current implementation doesn’t support Unicode strings in these specific contexts:

  • EVALUATE statement
  • MATCH built-in function
  • STRPOS built-in function

These are implementation-specific constraints that may be addressed in future releases.

Working Example: Practical USTRING Usage

MAP
  MODULE('API')
    GetSystemInfo(*LONG, *LONG), PROC, RAW, PASCAL, NAME('GetSystemInfo')
  END
END

MyName    USTRING(50)
MyCompany USTRING(100)
FullInfo  USTRING(200)
CharCount LONG
ByteCount LONG

CODE
  ! Assign Unicode content
  MyName = u'Αλέξανδρος'       ! Greek name
  MyCompany = u'SoftVelocity'   ! Company name
  
  ! Concatenate strings
  FullInfo = MyName & u' - ' & MyCompany
  
  ! Get character count and byte size
  CharCount = LEN(FullInfo)     ! Actual characters in string
  ByteCount = SIZE(FullInfo)    ! Total bytes allocated
  
  ! Display results
  MESSAGE('Name: ' & MyName & |
          '|Characters: ' & CharCount & |
          '|Bytes Allocated: ' & ByteCount)

Behind the Scenes: What Happens When You Concatenate

When you write a string expression like this:

Result = FirstName & ' ' & LastName

The Clarion runtime evaluates it using a string stack—a temporary workspace for building the final result. Here’s the step-by-step process:

String Expression Evaluation

Step 1: Push FirstName onto stack       → Stack: [FirstName]
Step 2: Push ' ' onto stack             → Stack: [FirstName][' ']
Step 3: Concatenate top 2 items         → Stack: [FirstName ]
Step 4: Push LastName onto stack        → Stack: [FirstName ][LastName]
Step 5: Concatenate top 2 items         → Stack: [FirstName LastName]
Step 6: Pop result into Result variable → Result gets final string

This stack-based approach doesn’t create temporary variables that need cleanup. The runtime handles all intermediate strings automatically, and they vanish when the expression completes.

Why this matters for you:

  • Write complex expressions freely – No performance penalty for chaining operations
  • No memory leaks – Intermediate results are cleaned up automatically
  • Thread-safe by design – Each thread has its own string stack, no locking needed
  • Efficient memory use – Stack allocation is faster than heap allocation for temporaries

Performance Implication

The string stack is why expressions like Name = FirstName & ' ' & MiddleName & ' ' & LastName don’t create memory leaks or slow down your application. Each intermediate result (FirstName & ' ', etc.) exists only temporarily on the stack and is automatically cleaned up.

Best practice: Write natural, readable string expressions. The runtime is optimized for this pattern.

Common Pitfalls and How to Avoid Them

Pitfall 1: Using SIZE() When You Mean LEN()

! WRONG - This won't work as expected
Name  USTRING(50)
CODE
  Name = u'John'
  IF SIZE(Name) > 10         ! Always TRUE (SIZE is 100, not 8)
    ! This always executes
  END

! CORRECT - Use LEN() for content checks
  IF LEN(Name) > 10          ! FALSE (LEN is 4)
    ! This executes only when needed
  END

Pitfall 2: Buffer Size Confusion

! WRONG - Allocating based on character count for bytes
Name     USTRING(50)
Buffer   STRING(LEN(Name))    ! Too small! Only 50 bytes, need 100

! CORRECT - Use SIZE() for byte allocations
Buffer   STRING(SIZE(Name))   ! Correct: 100 bytes

Pitfall 3: Forgetting the U Prefix

Greek  USTRING(20)
CODE
  ! INEFFICIENT - ANSI string converted to Unicode at runtime
  Greek = 'Αθήνα'

  ! EFFICIENT - Direct Unicode assignment, no conversion
  Greek = u'Αθήνα'

Migration from STRING to USTRING: Real Examples

Example 1: Buffer Sizing

! Before (ANSI STRING)
Name    STRING(50)           ! 50 bytes
Buffer  STRING(SIZE(Name))   ! 50 bytes

! After (USTRING)
Name    USTRING(50)          ! 100 bytes (50 × 2)
Buffer  STRING(SIZE(Name))   ! 100 bytes - SIZE() handles it correctly

Example 2: Loop Iterations

! Before (ANSI STRING)
Text  STRING(100)
I     LONG
CODE
  LOOP I = 1 TO LEN(Text)    ! Good - use LEN() not SIZE()
    ! Process Text[I]
  END

! After (USTRING)
Text  USTRING(100)
I     LONG
CODE
  LOOP I = 1 TO LEN(Text)    ! Same - LEN() still correct
    ! Process Text[I]
  END
  ! KEY: LEN() works the same way for both types!

Example 3: API Calls

! Before (ANSI STRING)
Buffer  STRING(1000)
Size    LONG
CODE
  Size = SIZE(Buffer)        ! 1000 bytes
  ! Pass Size to Windows API expecting byte count

! After (USTRING)
Buffer  USTRING(1000)
Size    LONG
CODE
  Size = SIZE(Buffer)        ! 2000 bytes (1000 × 2)
  ! SIZE() correctly returns byte count for Unicode APIs

Migration Considerations

When moving existing ANSI string code to USTRING:

  • Use LEN() for character-based logic, not SIZE()
  • Add U prefix to string literals containing Unicode characters
  • Test with international character sets if your application supports them
  • Be aware of the EVALUATE, MATCH, and STRPOS limitations
  • Review buffer size calculations—you may need double the byte count you used with ANSI

Looking Forward

The USTRING implementation provides a solid foundation for Unicode support while maintaining the Clarion language’s characteristic simplicity. The UTF-16 encoding, dual character set support, and clear LEN/SIZE distinction give you the tools needed for modern, international applications.

Key takeaways:

  • USTRING uses UTF-16 encoding (2 bytes per character)
  • Automatic conversion between ANSI and Unicode character sets
  • LEN() returns character count; SIZE() returns byte count
  • USTRING(n) allocates n × 2 bytes of memory
  • Code page awareness ensures proper locale handling
  • Runtime uses string stack for efficient expression evaluation

Thanks for being part of the Clarion community. If you try this out, let us know what you think — and stay tuned, there’s more to come.


Related: Clarion 12 Beta: USTRING Returns ANSI & Unicode

Clarion 12 is released



Clarion 12 Release

Clarion 12 is Here: Smarter, Faster, and Built for the Future

We’re excited to announce the official release of Clarion 12!

After a marathon development journey, this release delivers 100% backward compatibility and introduces powerful new features to enhance your development experience. Clarion 12 ensures your existing projects compile seamlessly — even those pushing the limits of the C11 compiler and runtime library (RTL) — while laying the groundwork for 64-bit binaries in the next release (C12 currently produces 32-bit binaries).


✨ What’s New in Clarion 12?


  • Just about every important IDE component, and close to 65% of the Runtime Library has been refactored, optimized and adjusted in preparation for the move away from the Topspeed compiler technologies and into a modern compiler architecture – it was both necessary and meticulous work required to get to the end goal of 64-bit. We’ve posted about version 12 many times, but here is a recap of some of the more recent and significant changes.

  • Improved Unicode Support with a Refactored STRING Type

    We’ve eliminated the complications of managing two string data types (STRING/USTRING). The improved STRING type simplifies working with Unicode, making your apps more compatible with global languages — and, perhaps most importantly, ensures 64-bit readiness for future updates.

  • Compiler Performance Improvements

    You’ll notice faster compilation times and improved code generation, making the dev cycle smoother and more efficient.

  • Foundation for 64-Bit Compatibility

    We’ve made significant improvements to the runtime library, laying the foundation for full 64-bit compilation in an upcoming release. This ensures Clarion remains future-proof for all of your projects.

  • “Check for Updates”

    On the IDE “Start Page” you’ll find a new Check for Updates button option that allows you to keep you up to date incrementally and effortlessly. When run, it displays details on any available updates, your subscription coverage, and links to your purchased products. Enhancements and Bug fixes to the IDE, RTL, drivers, and templates will reach you faster. When an update is available you can download and install the new version right from the IDE.

Let us know what you think, and thanks for being a part of the Clarion community!


Clarion 12 news

The Clarion 12 release was delayed past our initial January 1st target as we maintained our traditional end-of-year break, I had planned for us to work straight through but decided we needed the break to recharge. Here’s something else that is new in this release.

Microsoft SQL Server Driver Updates

We’ve rebuilt the Microsoft SQL Server driver with some new capabilities:

Security

  • TLS 1.2/1.3 support with related configuration options
  • Column-level encryption
  • Support for Server Certificate validation (including self-issued certificates)
  • Improved error handling for security operations

Note: these features require the Microsoft ODBC Driver 17+

Version Support

  • SQL Server 2005 through 2022
  • SQL Server on Linux
  • Azure SQL Database
  • Existing connection strings and configurations remain valid unchanged

Azure SQL Database Support

  • Azure Active Directory and Managed Identity authentication
  • Failover group support
  • Region-aware connectivity
  • Elastic pool connections

Backward Compatibility

As with all our releases, Clarion 12 maintains 100% backward compatibility. Existing applications will work without modification, and all new features are opt-in.

General ODBC Driver Improvements

The SQL Server driver improvements extend into our entire ODBC stack:

  • Refactored connection handling
  • Enhanced custom connection string support
  • More detailed error handling
  • Full compatibility with existing applications

PostgreSQL Support

Our ODBC driver layer provides enhanced support for the official PostgreSQL ODBC driver:

  • Improved connection string handling
  • Enhanced error reporting
  • Full compatibility with PostgreSQL’s native ODBC capabilities

SQLite Updates

And we’re working on new SQLite features:

  • In-memory database support
  • Improved transaction handling
  • Better concurrent connection management

Next

We’ll soon provide a web application where developers can sign up to test upcoming AI features in the IDE. The database improvements in this release are complete and are in final testing. We need a few more days of testing before we announce C12 GA. Thanks for you support and patience!

Clarion 12 – Upcoming release

Embracing the Future

We’re excited to announce the upcoming release of Clarion 12. While the release timeline has extended beyond our initial projections, we’ve used this additional development time to implement improvements that will benefit our entire developer community.

A significant improvement emerging from this extended development period involves our string handling architecture. While we had previously announced the introduction of a USTRING type to handle Unicode alongside the traditional STRING type for ANSI strings, we’ve arrived at a more elegant solution. Clarion 12 will feature a unified, enhanced string type that provides superior Unicode support while maintaining complete backwards compatibility. This streamlined approach not only simplifies development but also paves the way for an easier transition to 64-bit compilation in the future.

Beyond this architectural refinement, much of Clarion 12’s development has focused on building a solid foundation for future capabilities. We’ve made important internal improvements that, while not immediately visible, strengthen the platform’s core and prepare it for upcoming features.

Introducing AI-Powered Development

Clarion 12 marks our entry into AI-assisted development with a flexible, pragmatic approach. While our initial focus was on local LLM integration, we’ve built the system to accommodate any external LLM as we progress. During testing, we recognized that even machines well-suited for traditional software development might not handle local LLM processing efficiently. We’ve conducted extensive experiments with the LLaMA 3 series and various smaller models as local options, keeping the default choice flexible to accommodate different development environments.

This isn’t just another code completion tool – it’s a comprehensive coding assistant that truly understands (with your help) your application’s context and needs. For developers who prefer or require cloud-based solutions, we’ll also offer commercial AI integration options. This dual approach ensures everyone can access these powerful features, regardless of their local hardware capabilities.

Business AI: Today and Tomorrow

Clarion 12 introduces AI capabilities starting with practical IDE enhancements that streamline your development process. This is just the beginning of our AI journey. Just as websites became essential for business success in the 1990s, AI integration in business applications is becoming crucial for maintaining competitive advantage today. We’re laying the groundwork for you to capitalize on this opportunity.

Current IDE Intelligence

In this release, Clarion 12 includes AI tools to analyze your existing applications and suggest potential enhancements:

  • Comprehensive application scanning and analysis
  • Intelligent feature recommendations based on your specific business domain
  • Vector database creation for deep application understanding
  • AI-powered development assistance and code insights

Future Application AI

In upcoming releases, you’ll be able to integrate AI directly into your business applications:

  • Ready-to-use semantic search capabilities
  • Vector database integration with standard SQL databases
  • AI features that don’t require machine learning expertise
  • Templates and frameworks for easy AI integration into your applications

This phased approach ensures you can start benefiting from AI immediately in your development process while preparing for the next wave of AI-enhanced business applications.

System Requirements

For local AI features:

  • Minimum 16GB RAM
  • Modern CPU (12th gen Intel or AMD Ryzen 7000 series or newer recommended)
  • Windows 11 recommended (Windows 10 compatible but not officially supported for all AI features)

Standard Clarion development requirements remain unchanged for non-AI features

Looking Ahead

The release of Clarion 12 represents more than just an update – it’s a strategic step toward empowering our development community with next-generation capabilities. By focusing on practical AI implementation and maintaining our commitment to efficient business application development, we’re ensuring that Clarion developers are well-positioned to meet evolving market demands.

The release will be available before year-end, with updated documentation. We are also pushing hard to complete additional training resources, including videos and detailed blog posts, to help you make the most of these new capabilities. We’re exploring the possibility of featuring Clarion 12 on the ClarionLive channel. Stay tuned for specific release date announcements and early access opportunities.

Get Ready

We encourage all developers to begin planning their upgrade to Clarion 12. The improvements in this release, combined with the foundational work for future enhancements, make this a crucial upgrade for staying competitive in today’s rapidly evolving software development landscape.