What's new in Web Connection
not released yet
Add wwCookie Class for Response.AddCookie() improvements
Added a new
wwCookieclass to make it cleaner to add cookies with all of the available HTTP Cookie features that are available. Rather than passing a ton of parameters to
Response.AddCookie()you now can pass an object with simple properties set.
Windows Authentication for Web Connection Server Requests
Previously Web Connection server requests using the built-in Windows based authentication used only Basic Authentication. We've now enabled Windows Authentication so you can use either Windows or Basic or both. This also means you can now run with only Windows Authentication enabled in your Web Site as both the ASP.NET requests and Web Connection requests can authenticate with it.
Simplify Live Reload Configuration
Added new WebConnectionModule that handles
.htmlLiveReload script injection when LiveReload is enabled. This removes the need to explicitly enable a handler. The module automatically detects whether live reload is enabled and only injects content into HTML files if enabled. This simplifies configuration to the single
web.config. The WebConnectionModule is automatically configured for new projects.
Property** Added a newIsDirectory
property to the SftpFile object returned in thesftpFtpListFiles()` method to simplify figuring out whether an entry is a file or directory.
Fix: Live Reload Socket for Https Requests
Fix issue where Live Reload was failing in the browser when running on an HTTPS page. Page would work but browser would console log an error in the WebSocket Live Reload script. Fixed and you can now use https.
Add Live Reload Retry
When sitting on a page and shutting down the Web Server the Web Socket will disconnect and after that the page will not be able to refresh. Added code to retry the connection every several seconds to reconnect to the server so pages can be refreshed and the server can reach the browser from file changes.
Log Server User Account
We now log the server user account in Web Connection FoxPro server requests in the request log. This can be useful to ensure you can see which account your FoxPro server is running under.
Fix: Perf Counter Permissions
Trap errors in Web Connection Module Server list related to PerfCounter access - if access is not allowed, perf-counters are turned off.
- LiveReload Configuration Change for
If using LiveReload you will need to change the configuration to use the new
WebConnectionModule. To do this:
- wwRequestLog has Structure Changes
Please make sure you delete the request log (
wwRequestLog.dbfby default) or add an
account v(15)field to the table. Latest version detects if the field is missing and automatically deletes the table and creates a new one otherwise.
October 22nd, 2019
Preview: Local .NET Core Web Server Support
We've added a self contained .NET Core Web server that can run standalone without a Web Server installed, or as a backend service inside of IIS. The server can be run from the command line and has a number of options, including automatic support for Live Reloading of content. You do need to have .NET Core 3.0 installed. This is currently in preview and there's no explicit configuration support and all info on how to use this new server both for development and behind IIS is described in the documentation topic.
Preview: .NET Core 3.0 Support with
wwDotnetBridge allows interop with .NET and now there's basic support for .NET Core. r
wwDotnetCoreBridgeallows loading and executing of .NET Core components. As with the full framework version, wwDotnetCoreBridge hosts its own copy of the .NET Core runtime and then proxies into it create types and values that make it possible to access most .NET Core features from Visual FoxPro.
Add Edit Button to Web Connection Status Form
Added an edit button that makes it easy to open the site in an editor. There's a new
CodeEditorCommandLinethat can be used to launch an editor in the Web Site or the full project so you can quickly jump to editing the site. The default editor assumes VS Code (
Fix: Error Message Code Display
Fixed error message code display to be properly HTML encoded. If the code contained HTML to generate the error display would render the HTML. Fixed with proper HTML encoding so the code displays properly as code.
Fix: wwDotnetBridge Guid Results and Properties
Changed behavior of wwDotnetBridge methods that return Guid values or accss Guid Properties. Guids are value types and fixed up by wwDotnetBridge, but previously used the obsolete
ComGuidtype. This has been changed to use the standard
ComValuetype and the
GetGuid()method. So a method that returns a Guid returns a
ComValue, as does a Guid property accessed with
- ComGuid Class Retired for Guid Handling
Any wwDotnetBridge code that previously access Guid values, now uses the ComValue helper, which includes
NewGuid()helper methods. This is a breaking change, but provides better compatibility with all other special handling types which also use the
September 3rd, 2019
Simplified Live Reload Configuration
Refactored the way that Live Reload is hooked up to a 2 step process: Set the
EnableLiveReloadswitch and - for optional HTML file processing - enable the LiveReload Html Handler that intercepts requests to any
.htmfiles. This simplifies the configuration process which previously required adding a custom module and setting
runManagedModulesForAllRequestswhich had performance implications. See docs for more info on the new configuration features.
Visual Studio 2019 Addin Async Loading Enabled
Updated the Visual Studio addin to support async loading so the addin no longer shows load warnings on startup.
Fix JSON Handling for Large Strings and JSON Buffers
JSON size is limited by the FoxPro 16 meg limit, but due to the inefficiencies of JSON generation presizing a buffer the JSON string parser uses an overly pessimistic pre-sized buffer to hold JSON text that is passed to internal APIs. Changed the logic to maximize the buffer size at FoxPro's Max string size and handle errors if the buffer is overrun more gracefully. This will allow JSON string parsing up to the FoxPro 16 meg limit now where as before it was of the potential max buffer size.
Fix AppPool Creation Bug in New Installations
Fix bug where application pools in IIS weren't properly attached to the newly created sample site on first creation.
Cleanup Startup Launch.prg Handling
After setup and new project Launching now clearly shows what it's doing with messages to the desktop, so you new users can effectively re-run the application without having to look in the docs.
DO LAUNCHalways shows options now.
Server Live Reload for Server Code Changes
7.0 introduces updated Live Reload functionality without using Browser Sync. Rather there's now native support for live reloading in the Web Connection .NET Module. Live reload detects changes in Web client pages as well as server source code files. On the client changes are detected and immediately refresh the browser when saved. On the server changes are detected causing the Web Connection server to be shut down and restarted plus refreshing the browser. Note: This feature requires Windows 10 or Server 2012R2+ to work
Consolidated Launch.prg Behavior
Combined various Launch and Environment setup options into a single launcher that can launch your Web Connection applications in a variety of ways. Modes include: IIS, IISEXPRESS,SERVER,NONE. You can simply launch any of the modes with
DO LAUNCHfor the defaults.
Simple helper function that strips the Ole Dispatch error prefix from the front of a COM error message leaving just the actual error message text.
You can create a new
Launch.prgfor existing projects by generating a new project,copying
Launch.prginto your project and changing the configuration variables at the top of the file (usually the project name and virtual). The rest of the file is generic and portable.
Due to the changes in Live Reload functionality and for consistency the
lLiveReloadServerflag naming has changed. This flag was introduced in
7.05and generated in the
MyAppMain.prgmain program file of new projects.
Make sure to update WebConnectionModule.dll and Microsoft.WebSockets.dll
The new Live Reload functionality is implemented inside of the WebConnection .NET Module in
webconnectionmodule.dllso to use this new feature you need to update that file in all your Web projects. Also a new DLL,
Microsoft.WebSockets.dllhas been introduced to enable the Live Reload functionality.
wwHttp now supports String Downloads > 16mb
You can now download data larger than 16mb into strings. FoxPro has a 16mb string limit but with careful usage you can access strings much larger than 16mb as long as the strings are not updated. wwHttp has always supported downloading larger files directly to file and this is just another option that works by default.
wwHttp large File Download Speed Improvement
Changed the wwHttp buffer sizing behavior to dynamically size the buffer depending on the download size. Larger buffers drastically improve download performance of large HTTP payloads easily improving 5 fold for megabyte sized downloads.
Add Option to not Allow Html in Markdown Parser and Function
MarkdownParserclass now have options to disallow HTML markup inside of any Markdown parsed. This can be useful to cut down on possible XSS attack vectors that go beyond the XSS prevention already built into the Markdown parsing process.
wwSFTP Client now fails if renci.ssh.dll is missing
wwSFTP now immediately fails if the SSH library used for the SFTP connection cannot be found on startup. Previously this resulted
Undefined COM Erroron sending - you now get a specific warning that points at the missing assembly.
Updated Weblog Sample Comment Management
Comments are now moderated with an email sent when a new comment arrives, and authenticated users can remove comments in a post or in the main comment list. This fixes a serious SPAM targeting issue with un-moderated spam.
Performance Improvements For Request Processing
Optimized a number of API calls commonly used by reusing API declarations for a number of common operations. Removing repeated
DECLAREcalls on API calls for many often reused functions should trim a little overhead in request processing times inside of the Fox server.
Fix: DLL Naming Problems in New Project Wizard
Fixed bug with New Project Wizard that failed to copy multi-segment named DLLs into the new project folder correctly. Specifically,
renci.sshnet.dllwere truncated to (
renci.dll). Fixed. Please update your project folders with updated DLLs from this release.
- There are no breaking changes in 7.05 but as always you'll want to upgdate your DLLs in your projects to the latest from the Web Connection folders. Update the Deploy folder DLLs and the
March 6th, 2019
No Breaking Changes • Update Notes
wwApi ZipFolder() and UnzipFolder()
.NET based folder zip functions that work of source and target folders on disk. Basic zipping and unzipping features only but handles special files and long file names better than the old
Add support for Binary Data to wwXml::XmlToObject/ObjectToXml
wwXML can now serialize and deserialize binary data (of type
Q) to and from XML using base64 serialization.
Allows you to set the SQL Connection timeout globally before a connection is made.
Added a property to control the authentication timeout for the session cookie set for authentication.
GetFileName() and GetDirectoryName() wwUtils Helpers
These methods are similar to
JUSTPATH()except they preserve the case of the input path.
Refactored Server Error Handling
The wwServer class has some updates that simplify how errors are handled, displayed, logged and emailed with dedicated methods that handle these tasks. New methods in include
wwServer::ErrorMsg()that is used to display an error page.
New Project Wizard now copies DLLs to Deploy Folder
When you create a new project, the Wizard now automatically copies all Web Connection dependent DLLs to the Deploy folder, so that running standalone without the IDE and the generated
config.fpwdoesn't cause errors due to missing DLL dependencies. It also makes it clearer that those DLLs have to present for deployed applications.
Fixes to the
Fixed a number of small issues related to how
Launch.prgis generated and started initially when a new project is generated.
January 24th, 2019
New wwDynamic Class
Added a new dynamic object class that allows for creating or extending objects with dynamic properties that are created as you reference them. Ideal in scenarios where you need to return 'tuple' like object results from methods or where you dynamically need to build up object structures in user code.
Add Launch.prg to Project Template and Samples
New projects now have a
Launch.prggenerated that makes it super easy to start up a Web Connection application from FoxPro. The file supports launching either IIS or IISExpress (if not running it will launch it) and navigate to a default page that you can change. It'll set up default paths, bring up the Web connection server, open the start page for the project. The PRG can be customized for your specific environment and it's a great way to have an easy way to start running your application for the first time.
Setup and New Project Wizard Improvements
Both the Setup and New Project Wizard now show detailed information about how to launch your applications in the FoxPro desktop. Instructions show how to launch your server (via the new
Launch.prg) and what URL to navigate to. Paths are automatically configured. Setup automatically launches the sample application now, the New Project Wizard displays a message on the desktop.
Setup now Prompts for IIS Installation
The Setup wizard now explicitly asks to make sure that you have IIS or IIS Express installed and if not takes you to the documentation with installation instructions. This hopefully prevents people from installing Web Connection when the Web Server is not installed yet.
WebLog Example converted to MVC Style Scripts and Templates
The Sample Weblog Application that ships with Web Connection has been re-written to work as an MVC style application from the original Web Control Framework application. Most of the UI remains the same, but the underlying framework has been switched to use MVC style Models and Scripts to present that Web UI. There have also been a few enhancements including support for Markdown comments, a new Comment editor, and an integrated mechanism to delete comments and posts through the main interface rather than in a separate admin screen. This application is shipped in the Web Connection
wwHttp::AddPostKey() tcExtraHeaders Parameter
AddPostKey()that allows specify extra HTTP headers for multi-part form values posted.
wwHttp .Get(), .Post(), .Put(), .Delete() Methods
Added wrapper methods for specific Http Verb operations for clarity.
HttpGet()was always a misnomer for non
GEToperations and these functions are meant purely for code clarity. They have the same parameters as the
You can now get a list of TLS certificates installed on the local machine to potentially pass to requests.
wwHttp::lDecodeUtf8 to automatically decode UTF-8 Content
Added a new wwHttp::lDecodeUtf8 property that is
.t.by default to decode UTF-8 content based on the
wwCollectionto allow for finding elements by their value. You can now search any type of element including objects. New
Set()property allows setting a value if it exists or add a new one if it doesn't. A new
RequiresUniqueItemsproperty allows collections that can't have duplicate values. The
Item()method fixes a few scenarios where non-matched items would fail and now return null.
wwUtils GetRelativePath() Function
Added a new function that returns a relative path. Unlike
SYS(2014)this function returns the path in proper case.
wwUtils SaveFileDialog() and OpenFileDialog() Functions
Save and Open file dialogs that unlike
GETFILE()return the filename and path in proper case so files can be saved and retrieved by their actual on disk filenames.
Rounds out routines to write out Json values as string in addition to
All Web Connection DLLs and EXEs are now digitally signed
Web Connection is now built with a proper build process that builds the entire product in an automated fashion. Previously some parts were using this automated process but it has now been fully automated. As part of that process all West Wind DLLs and EXEs and Setup files are signed with a digital signature to allow verifying authenticity. This will also make it less 'scary' to run the installer for the first time if Windows SmartScreen is is enabled.
- wwResponseFile.prg and wwResponseString.prg Consolidated into wwResponse.prg
Consolidated the legacy response object classes into the single
wwResponseclass file which now contains all three of these classes. This removes two additional files from a base install. These objects are now only used as pass through objects proxying for
wwPageResponsethat's used for all actual Request object operations.
To update: You'll get compilation errors for missing files - just choose remove when prompted to remove them from the project.
November 16th, 2018
Template Updates to BootStrap 4 and Upated Support Libraries
Overhauled the default project templates to use Bootstrap 4 and FontAwesome 5 and updated overall styling to be more up to date. Updated related components like the date
HtmlDateTextBox()to use tempusdominus-bootstrap-4 date picker control. Helpers support both Bootstrap 3 and 4, via a compiler switch
BOOSTRAP_VERSION 4. There have been many tweaks and updates to the styles for cleaner rendering and a number of new support styles have been added.
Fix: Remove hardcoded Content Page Paths from Scripts
Changed the generated PRG output for content pages so that the content page path is no longer hardcoded into the page code. This fixes issues where if a compiled FXP was moved to a new location it would fail due to an invalid template path. Updated code provides the content page path up the call stack and persists it into the layout page.
Updated Visual Studio Templates and Intellisense Snippets
We've created 20 or so Intellisense snippets (Ctrl-k-x -> My Html Snippets -> Web Connection) that let you quickly inject common Web Connection and Bootstrap controls/components into the page with minimal effort. We also provide Visual Studio Code Page Snippet templates for Layout, Content and Standalone pages.
Visual Studio Code Web Connection Code Snippets
We've added a number of helpful code snippets for Visual Studio Code for inserting blocks of code for common Web Connection components in scripts and templates are available. Type
wc-in the editor to see the VS Code snippets.
Generic Markdown Page Rendering
New projects now include the ability to render any Markdown page with an
.mdextension and render it into HTML. You can simply drop a Markdown file into a folder add any dependent images and have that page rendered. A custom
Markdown_Template.wcstemplate can be customized to provide custom page layout for site chrome to match your site's identity.
<% %>Scripting inside of
You can also use script and expression tags inside of Markdown blocks to effectively script Markdown text.
Updated Markdown Island Support in Scripts and Templates
Web Connection has support
<markdown></markdown>tag islands into which you can put Markdown text that is rendered as HTML for a while. Previously you had to left align the Markdown content. With this release Markdown content no longer has to be left aligned, rather the parser detects the common space before all lines and strips it.
New Projects automatically create local Git Repository
If Git is installed locally, the New Project wizard now automatically creates a Git repository in the new project and creates a first commit. You can easily continue committing and always roll back to the initial install. If you don't like the git repo - remove the
.gitfolder and it's gone.
All authentication releated Process properties -
cAuthenticatedUserName- now explicitly call
OnCheckForAuthentication()if it wasn't previously called, ensuring that authentication is always checked when accessing these properties. Previously you had to explicitly call
OnCheckForAuthentication()which is no longer necessary. A new internal flag ensures that authentication is checked only once on repeated accesses as it accesses the session store to check or retrieve the auth token.
Updated wwUserSecurity logic to automatically create
.oUserSecurityand .oUser` objects on each requests. When accessing these objects Web Connection checks to see if they already exist and if not they are created. If a user is not logged in, an empty oUser record is created and you can check for an empty user with oUserSecurity.IsEmpty().
wwUserSecurity Password Encryption Improvements
wwUserSecurity will now automatically encrypt a password that's not already encrypted if
cPasswordEncryptionKeyis set to encrypt passwords. You can now add a non-encrypted password into the file, and next time the user is authenticated the password will be encrypted and written into the database in encrypted form.
wwUtils.SanitizeHtml() to sanitize HTML strings Added a new SanitizeHtml() function to wwUtils to strip scriptable code out of HTML text. Useful for cleaning up user captured HTML or Markdown text to prevent XSS attacks from user input. Requires .NET.
Response.ExpandScriptAsString() and Response.ExpandTemplateAsString()
These two functions can now be called to parse a script or template and return the output result as a string rather than writing output into the Response stream as complete pages. Render pages or partials into HTML and use them from process class code directly. Although we recommend using scripts and templates along with Partials to do embed external templates, it can sometimes be useful to 'call' a partial component directly from code. For example a Login Partial component might be rendered into non-script pages and can just be embedded as a string. These functions are mere wrappers around
tlReturnAsStringparameter - they are provided for easier syntax and better discoverability.
Update Project Template and Add HelloScript Request
Add a new script page to the default template that demonstrates running a request using MVC style development by using the a script page with code behind. The script page renders the current request list, displays a message alert box and describes several aspects of the MVC process.
Add BrowserSync.prg to new Project Template
New projects now get a
Added a method that can produce HTML output from an RSS Feed. The method is customizable with a
HtmlRssFeedConfigthat allows control over number of items retrieved and a number of formatting options for the feed.
New File Upload Samples
Removed the overly complex plUpload component from Web Connection and instead provided simpler pure AJAX examples as well as a simpler and much more modern uploader called Uppy. There are simple file upload samples, and an example of uploads displaying in an image carousel.
wwPdfPrinterDriver PDF Printer for wwPDF
Added a generic PDF driver that can be used with any printer driver that outputs to PDF including the built-in Microsoft Print to PDF driver in Windows 10 and Windows Server 2016 and later. This driver handles report printing, capturing and waiting for the output file from the print spooler and dealing with unattended mode issues when running in COM modes.
wwDotnetBridge - Automatically unblock DLL
Added logic to automatically unblock
wwDotnetBridge.dll. This should help with many common loader error issues.
Improved Error Message for wwDotnetBridge Load Errors
wwDotnetBridge has a few rules required in order to run it - specifically related to Internet downloaded-loaded DLLs and loading from a network. Updated the loader error message with common causes and link to documentation.
wwDotnetBridge Fixup for List
Added additional support for
List<T>return values to
GetProperty()results, which returns these values as a ComArray now.
wwDotnetBridge Support for Creating Generic Types
You can now create generic .NET types like
Dictionary<t,t1>. A new method on
ComValue::SetValueFromCreateGenericInstance()allows you to create a generic type on the
ComValuestructure. Since generic types are not directly accessible from FoxPro (no support for COM interfaces on generic types) interfacing with these types always goes through ComValue and indirect ac
Added method hook that is called after a user is logged out. This is useful for removing additional application specific state that might be saved in session or other application data stores.
wwProcess::InitSession(): New llSecure parameter
You can now specify that the Session cookie created can only be used under HTTPS via the
llSecureparameter. This translates to the
Secureflag of the cookie created.
wwUtils GetFullPath() Function
Function that resolves a relative path to a full path but also matches the proper case of the file on disk if it exists.
Bootstrap 4 and FontAwesome 5
Web Connection switches default templates to Bootstrap 4 and FontAwesome 5 (free). Bootstrap and Fontawesome syntax have changed somewhat for these new frameworks. These changes don't affect any existing applications, except for: the
HtmlErrorDislay()which are affected by the changes. If you need to use the old version of Bootstrap use the
wconnect_override.h. If you decide to upgrade applications to Bootstrap 4, most bootstrap concepts work, but there are number of differences you have to account for. The list is long but in Web Connection's own templates only very few things were affected mainly panels (cards now) and wells (also cards).
wwSql and wwXml Classes now are PRG classes
We've switched wwSql and wwXml to run as PRG classes in order to simplify distribution and compilation. You will need to update your project references to the PRG files and any declarations from
SET CLASSLIB TOto
SET PROCEDURE TO. You should just be able to do Replace in Files in your Favorite editor or explicitly use GoFish to find and fix up any references to wwSql or wwXml.
wwBusinessObject replaces wwBusiness as a PRG class
wwBusiness.vcxwith a PRG based version called
wwBusinessObject.prg. Unlike the wwSql and wwXml classes, we've explicitly renamed the PRG and class to
wwBusinessObject. The old version will still be available in the
OldClassesfolder for those that need visual classes but any new development will be made only on
wwBusinessObject. To replace search for any references to
SET CLASSLIB TO wwBusinessand replace with
SET PROCEDURE TO wwBusinessObject. Find any class references to
AS wwBusinessand replace with
AS wwBusinessObject. If you are using a VCX based subclasses of
wwBusinessyou have to continue using old wwBusiness.vcx unless you explicitly migrate the visual class to a code class - you can do that easily with the VFP Class Browser export feature. I suspect the same is true for most applications.
wwDotnetBridge support for Event Handling
wwDotnetBridge now supports subscribing to and handling of events via the new
loBridge.SubscribeToEvents()method. You provide a source .NET object that fires events and a FoxPro object that implements the corresponding event methods that you want to implement. Thanks to Edward Brey who built out this feature in the OSS version of wwDotnetBridge!
New .NET Runtime Loader and better loader Error Handling
Updated the wwDotnetBridge .NET CLR to using current loader APIs which provide for better error trapping. Load failures should now provide improved error information to client if the .NET Runtime bootstrapping fails.
Console Command for Disable Loopback Checking
On servers and now also on newer versions of Windows 10 IIS enforces local loopback check policy which doesn't allow for local Windows authentication to work. If you try to access the Admin pages with authentication it will fail if the policy is applied. We've added a new command
console.exe disableLoopbackCheckingto disable this policy.
April 17th, 2018
Support >16meg uploads with wwHttp
You can now upload files larger than 16mb with wwhttp by using the new
lUseLargePostBufferflag and setting it to
.T.. Internally this class uses a file stream buffer to hold the POST buffer.
Updated wwFileStream Class to create >16mb Strings
The wwFileStream class provides a file based stream that allows creation of large strings that exceed 16mb and can be loaded into FoxPro strings as a whole. FoxPro supports >16mb strings in limited fashion (basically >16mb string can't be mutated), and this class allows you to create those strings.
Added helper method to send emails using the configuration settings made in
<yourApp>.ini. This makes is easier to send confirmation and notification emails from within your code.
messageParameter for Login
Authenticate("Login")method and the stock Login form now support displaying of a message as part of the login form by providing a Query string parameter for example:
wwJsonSerializer::Serialize() llFormat Option
Serialize()method now has an
llFormatparameter that allows specifying that the content should be pretty formatted. This is in addition to the
FormattedOutputflag on the serializer itself.
Fix: File2Var() UTF-8 Detection
Fixed bug in File2Var() that would cause problems with UTF-8 BOM detection in non-Western alphabets.
Fix: wwEncryption with Upper ASCII Characters
Fixed issue with wwEncryption not properly two way decrypting upper ASCII characters as the Code Page mapping was off. Switched to UTF-8 character sets when encoding and decoding which works on all ANSI codepages as long as the same code page is used to encode and decode.
Fix: .NET Module AdminAccount with multiple Accounts
Fix issue where AdminAccount was not properly working when multiple accounts were configured - account wouldn't validate against the list. Fixed.
February 7th, 2018
Security Weblog Post
Security Update: Update Admin.aspx Page to Disallow Unauthenticated Remote Access
Added logic to the Admin page to disallow access to the Admin page when not authenticated. Local machine access only displays an error message just like previous versions, but remote access now shows an error message and does not display the admin page links.
wwRequest::Form support for > 16meg Strings
Added support for reading Form variables when the Form buffer is greater than 16megs. FoxPro supports strings > 16megs as long as the string is not manipulated with any string mutating functions. But most importantly you can write a > 16meg string easily into file. More info.. Thanks to Keith Hackett for providing this solution.
Added an additional wwServer hook method that is fired after the server is initialized. This hook can be subclassed in the wwServer subclass, and is called after the server has been initialized but before the first request and
January 9th, 2018
Release Blog Post
Add back Apache Support and support Apache 2.4.x
Due to a number of requests from customers as well as generous support by way of contract work sponsored by James Heuer, we've added back support for Apache. Apache was dropped in Web Connection 6.15 and is now back with Apache 2.4 support plus a few additional new features.
Improved and simplified Apache Configuration
The New Project Wizard now works more reliably with automatically setting up an Apache server configuration. Configuration also has been simplified a bit with new features added to Apache for configuration of virtuals and scriptmaps. There's also better compatibility with direct support for
APPL_PHYSICAL_PATHsettings available the Apache request pay load which makes Apache more compatible with IIS's ISAPI implementation.
JsonDate() function in wwUtils
JsonDate()function that creates a JSON formatted date string that is properly UTC adjusted. Function lives in wwUtils but requires wwDotnetBridge/.NET to work.
Unload and Reload Individual COM Servers
There's a new
shutdowninstance.wc?pid=1234maintenance request for COM servers that shuts down a running COM instance that will be reloaded on the next hit. This can be used to remotely or internally restart individual instances that may be running with too much memory. Uses the Process ID as identifier.
Fix: Close FoxPro when Web Connection is Running
Fix issue where FoxPro cannot be shut down when Web Connection is running inside of the IDE in file mode with Cannot Quit Visual FoxPro error message. Hooked window events so shutdown works as expected in file mode. There's now also a wwServer::Shutdown method that is called when the server is shutdown - in file mode only.
Fix: wwJsonSerializer UTC Formatting
Fixed problem with the wwJsonSerializer where UTC dates weren't properly showing time zones other then current time zone.
Fix: wwJsonSerializer Deserialization Property Names
FoxPro supports only alpha-numeric plus
_for property names and this filter ensures that deserialized properties are cleaned up to remove all but those characters via a new
- wwJsonSerializer::Serialize() now relies on .NET
The wwJsonSerializer now uses .NET functions to serialize date values with proper UTC conversions that previously weren't handled.
wwJsonSerializer::DeserializeJson()already depended on .NET so not a big change.
October 16th, 2017
Release Blog Post
Better Error information for wwDotnetBridge Load Errors
wwDotnetBridge will now report slightly better error information on load failures, when failing to load the runtime or initial wwdotnetbridge instance.
Browse Button on the Server Form
The server form now has a Browse Site button that can open a browser window with the configured HomeSite url.
JsonSerialize() and JsonDeserialize() Helper Function
Added helper functions that let you use the JSON serializer without having to create a new object instance of wwJsonSerializer for each serialization process operation. The helpers simply wrap the
DeserializeJson()methods for easier usage.
Updated Process Templates
The default wwProcess templates for new process classes have been updated with a few enhancements: The template automatically adds Intellisense references for
THISand the Web Connection top level intrinsic objects (Request, Resonse, Server, Session) via
#if .F.blocks hide the the directives from executing code but allow the editor to find the Intellisense references. Process classes now also default to Scripts for missing controller/process class methods (ie headless scripts).
Buid Script Updates
build.batfile generated into a new project folder to create a packaged application ready for deployment has been updated to create a more complete deployment package. Previously the script only pulled the EXE and all the Web Connection system dlls required to deploy the binary folder. The updated script adds the Web and Data folders by default and creates the same structure as the project with Deploy/Web/Data top level folders.
Improvements in COM Server Load Times
COM Servers now load slightly faster as the COM load sequence has been optimized further after the last releases parallelization of server loading onto pool threads. Servers are now loaded onto MTA threads (rather than STA), which provides faster startup and less overhead in ASP.NET.
COM Server Loading Changes
We've made some changes to the way servers are loaded by separating the
OnLoad()steps to before and after actual server constructor operation. Previously both operations occurred in the confines of the FoxPro
Init()constructor function which meant any error forced an immediate abort without error information. Now
OnLoad()is fired after the server instance has been created and we can trap errors and display them when the first hit comes in. If an error occurred during load all subsequent requests display that load error - the server is effectively disabled, but you get full error information where previously the server would have not loaded with a cryptic COM error. This should also help with server load speed as load behavior is delayed until after the instance has been returned.
Server Count can now be Interactively set on Admin Page
You can now set the server count interactively on the admin page when using the Web Connection module. This means you can immediately change the number of instances that start up in COM or File Mode with Auto Server start.
Exe Servers hotswapped now automatically re-register for COM
When servers are uploaded and hotswapped via the Web Connection module, servers are now automatically re-registered with the
-regserverflag after successful upload. This should avoid problems if properties or methods were added to the COM server.
New Install-IIS-Features Powershell Script
Web Connection now ships with a Powershell script called
Install-IIS-Features.ps1that can be used to install IIS on a Desktop or Server that doesn't have IIS installed. The commands install the Web Service feature/role with all the options required to run Web Connection.
- Web Control Framework no longer loaded by Default
We've disabled the
wconnect.hwhich means by default the Web Control framework libraries will not be loaded any longer by
wconnect.prg. To enable Web Control framework loading you can reenable the
#UNDEFINE WWC_LOAD_WEBCONTROLS #DEFINE WWC_LOAD_WEBCONTROLS .T.
- Re-Register COM Servers
This release makes changes to the COM server interface of the wwServer class which requires for the type libraries to be updated. Make sure you re-register your server with
yourServer.exe -regserveror by using the new hotswapping features which auto-register the server after upload.
May 30th, 2017
An explicit function to initialize the .NET Runtime for the entire application. Although this function doesn't really do anything but create an instance of wwDotnetBridge with a specific version, the function makes it clear that this initializes the .NET version for the entire application.
Added properties to set dynamic properties on the user record. This allows you to add custom values to the user record without having to extend the schema explicitly (although you can do that as well - add a field and loSecurity.oUser.NewField).
Updated GetUniqueId() to be more Random
Changed the algorithm of GetUniqueId() using Guids that are redistributed over printable characters. The result is truly random Ids that are more unique with much smaller character counts - as little as 8 characters can provide safe ids for low impact applications with a max of 16 for near 100% fidelity.
Add content type to wwHttp::AddPostKey() when uploading files
You can now specify an optional content type when uploading files to a server using
.nHttpPostMode=2. The content type is appended to the file data sent to the server.
Fix: HMACSHA Hashing in wwEncryption
Fixed a salt encoding bug in the
ComputHash()function when calling the HMAC specific methods that require a salt value. Previously the salt value were added to the original string and then encoded. Now the salt value is only applied to the HMAC algorithm processor.
Fix: wwSFTP Large File Upload
Fixed an issue due to a buffer size issue with the underlying SSH library used in wwSFTP. Fixed by ignoring the
< %: expr % > for Templates and Scripts
Scripts and templates can now use automatic HTML encoding by using
< %: expr % >instead of
< %= EncodeHtml(expr) % >(spacing added for rendering). This makes it much easier to create XSS safe string output without more verbose syntax.
Visual Studio 2017 Addin Support and Visual Studio Gallery
The Web Connection Visual Studio Addin now supports Visual Studio 2017 and is also published to the Visual Studio Extension Gallery. This means you can install and update the addin directly from Visual Studio and once installed, the extension can automatically update itself.
New wwSFTP Class for SSH based FTP
There's a new wwSFTP class that provides secure FTP (SFTP only, not FTPS) to connect to SSH based SFTP servers. The class inherits from wwFTP so can be interchangeably with wwFtp based FTP code.
wwUserSecurity Password Encryption via cPasswordEncryptionKey
You can now encrypt your UserSercurity table's passwords by setting the
cPasswordEncryptionKeywhen you create your wwUserSecurity instance. When set passwords are automatically hashed before getting saved to the database.
wwEncryption::ComputeHash() adds HMAC Hash Algorithms
wwEncryption::ComputeHash() adds HMACSHA1, HMACSHA256, HMACSHA384 and HMACSHA512 algorithms. HMAC algorithms use complex salting cycles to add complexity and delay to generated hashes using an industry standard and repeatable algorithm.
wwRequest::GetLogicalPath() can return Proxied Urls
GetLogicalPath() now gets a parameter that when true will return the original URL specified before a proxy redirected the URL to your application. Useful when using extensionless URLs redirected via Rewrite rules in IIS.
Switch to Markdig Markdown Parser
Switch markdown parser to use the MarkDig .NET Markdown parser which natively supports Github flavored markdown and many Markdown extensions, including support for auto-links, extra emphasis (strikeout, sub/superscript etc.)
Allows generation of unique IDs based off a full or partial GUID value. Allows specification of a size that determines the size of the generated string between 15 and 32 characters where 32 is a full GUID.
String utility like ALINES() to return a collection of strings that allows you to specify a length to break lines at. Uses ALINES to capture lines and splits lines longer than specified via MEMLINES(). Useful for any code parsing that needs to ensure string literals don't exceed 255 characters in length.
wwDotnetBridge now supports TLS 1.2
wwDotnetBridge now sets the default HTTPS protocols settings to allow for SSL3, TLS1, TLS11 and TLS12. The default previously only allowed for SSL3 and TLS1. Overrides
ServicePointManager.SecurityProtocolon initial load of the .NET runtime. This affects any .NET API called that uses HTTP including Web service calls.
Explicit function that can be used to compile a single ASP Script page using the same mechanism used to run the page.
WCSCompile for pre-compiling Scripts on the Server Fixed the pre-compilation link on the Admin page that allows recompilation of Scripts (wcs style FoxPro script pages) on the the entire site. This feature now works recursively and can reliably compile scripts assuming all referenced dependencies used in scripts are loaded by the application before compilation occurs.
You can now create a new instance of wwHttp to be used in the wwJsonSerializer implementation when making service calls. You can create a new instance of wwHttp that is pre-configured with Authentication, headers etc. and pass it to this method before a service call.
wwUserSecurity Table Changes
The structure of the Usersecurity table has changed and the table structure has to be updated in order to work. Various fields have been expanded for supporting better security and encryption and field types have been changed to var chars instead of fixed width fields for simpler code and more efficient storage. Make sure you check the structure of the table in wwUserSecurity::CreateTable().
Add Markdig.dll to your Distribution
The new Markdig Markdown parser requires a new DLL to be used. If you're using hte
MarkdownParserclass or the
Markdown()function, make sure to update to this DLL. You can remove
September 16th, 2016
Angular 2.0 Project Template
Added a pre-configured Angular 2.0 template that is post-installed into a newly created project. A new walk through describes how to set up a new Angular 2.0 project.
wwUtils GetWords() Function
Added a new function that parses a string of multi-word text into a collection of words.
Updated Project Templates
Updated the project templates and Console Project Wizard to generate more comments and notifications when a new project is created, so it's easier to known what to do after the wizard finishes.
June 10th, 2016
no breaking changes
View Fox Code from Visual Studio Addin for Scripts/Templates
You can now see the FoxPro Code option on the Visual Studio context menu for scripts and templates and even static HTML pages if the page contains
SourceFile="<filename>". The file name can contain a
~virtual path like:
SourceFile="~/../Deploy/MyProcess.prg"which points back to the source code folder from the Web folder.
Web Connection Handler File Upload
In addition to being able to upload a server EXE file, the handler now supports uploading of arbitrary files to the application's
deploy\tempfolder from the Handler admin page. This makes it easier to push files to the server without having to install an FTP server. Make sure you set the application's request limits to allow larger uploads.
wwDotnetBridge::InvokeMethodAsync() and wwDotnetBridge::InvokeStaticMethodAysnc()
New method that allows invoking .NET methods on an instance asynchronously. You pass in callback object that receives
OnError()callbacks to get notified of completion of the async operation.
Function that returns a human readable string date or time (English only) such as just now, 10 minutes ago, 3 hours ago, yesterday. Anything over a year is turned into a short date: May 1, 2015.
wwUtils::FormatValue and wwUtils::FormatString
Two methods that use .NET string formatting to allow you to use sophisticated string formatting in FoxPro. Easily create nicely formatted date strings, MIME or ISO date formats, non-padded number strings formatted to decimal places with automatic localized formatting.
cursor_legacy:cursorNameto wwJsonSerialize table serialization
You can now serialize cursors in the 'old' default format which included
Countproperties for the actual data array and record count. Provided for backwards compatibility.
Fix wwMaint Server File Editor
Fix bug to properly write the correct file out to disk.
New Project Wizard
Created an updated New Project Wizard that creates a self contained directory structure that holds code, data and Web content. The Wizard also auto configures all paths and related links in such a way that the application should be xcopy deployable if you take the entire folder structure to the server. The new structure links back to Web Connection source files in the original Web Connection install folder, and separates logic for your own projects away from the Web Connection core files.
New Project Wizard can now generate a REST Service
The new project and new process Wizards now include an option to select the process class type to create. You can either create a standard Web Connection wwProcess class or a wwRestProject. The Rest project creates a service method sample.
New Projects generate a Server Configuration Script
The New Project Wizard now also generates a
<YourApp>_ServerSetup.prgfile that is FoxPro PRG based script that can configure your Web application. The script is linked from
<YourApp>Main.prgand can be run it
<YourApp>.exe configfrom the command line in a deployed application.
Partial Pages Script and Templates
There is now support for partial page references that allow you to render child pages from your Scripts and Templates. You can simply reference child pages with Web relative paths using
< %= RenderPartial("~/PartialPage") % >where the ~/ points to the root of the Web site. You can also hard reference a file with a full path.
Scripts and Templates now support multi-line expressions
Script and template pages now can use
< %= expr() % >tags that span multiple lines with line breaks. This especially simplifies use cases where you use complex Html Helpers that include style information. All line breaks are converted to spaces. NOTE: This can cause a problem if you have literal strings that include CHR(13) or CHR(10) values.
Native Markdown Support in Scripts and Templates
Script and template pages can embed
< markdown >and
< \markdown >tags to embed Markdown text into the markup. The Markdown is parsed inline as the Script or Template page is parsed.
Improved handling of Extensionless Urls
Extensionless URLs are common on the Web and this version of Web Connection adds improved support for them by providing a clean re-write rule (needs to be uncommented) and some additional logic in
Layout Pages and Sections for Script and Templates
You can now also create Layout or "Master" pages for scripts and templates that serve as 'common content' containers for content pages. Layout pages typically contain HTML header and common page chrome data - page headers, menus, sidebars that are common to many pages. Layout pages are called from Content pages via
< % Layout="~/_layout.wc" % >which renders the layout page, which in turn renders the content page into a
< %= RenderContent() % >area. Layout pages can also contain section directives to let the content page provide content to embed into the Layout page.
Completely Rewritten Message Board
The message board sample application has been re-written from scratch as an MVC style application using the scripting features in Web Connection 6.0. This application serves as a full featured example for doing MVC style development with Web Connection.
New Markdown Parser
MarkdownParserExtendedclasses that allow parsing of Markdown text to HTML. Markdown is a popular text editing format for developer Web sites and CMS systems that simplifies text input via the simple markup formatting of the Markdown Syntax.
Added a small function that allows 'debouncing' events to a specified number of milliseconds. Allows throttling high volume events like
window.resize()or drag events to be held and fire only at specified intervals to avoid overloading and hanging the browser.
New Visual Studio 2015 VSIX Add-in
The Web Connection add-in has been updated to a full VSIX add-in that can be installed from Explorer by double-clicking. Functionality has also been updated to support View In Browser functionality for any type of HTML file including Web Connection Script files to make it easier to launch in the browser. If no configuration is provided the View in Browser feature still works with the default project configured URL.
Resolves a virtual path (~) to a physical path on disk by replacing the virtual path specifier with the application path.
Allow Console.exe to run out of folders other than Wconnect Install Folder
Console.exe can now run from any location. When the console run it'll now explicitly change path to the /wconnect install folder and change back to the original folder when complete.
.NET Handler Faster COM Server Loading
Initial loading of COM servers when the servers are loaded has been improved significantly by removing a redundant load/unload cycle. Servers should now load twice as fast as previously.
.NET Handler now allows Hotswapping of File Based Servers
You can now use File based messaging with the .NET Module and hotswap EXE servers. Like the COM Server feature, hotswapping allows dynamic updates of the server EXE file without shutting down IIS/Application Pools.
.NET Handler StatusPage Updates
The .NET module now supports ~\ virtual paths for TempPath and ExeFile paths, and the status page now displays the fully resolved OS path.
Method that allows wwDotnetBridge to set a value from the .NET
System.Convertstatic class in a simpler way. Allows access to all
ComValue::SetUInt64 and SetUInt32 Methods
Added additional type conversions for UInt64 and UInt32 values.
New method adds the ability to retrieve an indexed value from an IList based object like arrays and generic lists.
New Html helper that renders the BootStrap DateTimePicker or optionally a native UI on mobile devices.
wwHtmlHelpers HtmlDataGrid OnAfterRowsRendered Event
Added an event that is fired when all rows in the grid have rendered. You can attach an expression that can then render HTML to inject additional HTML like a footer.
Updated HtmlErrorDisplay to use BootStrap alert themes and use font-awesome icons. Also added HtmlErrorDisplayConfig class that can be used to configure this method, as well as work as standard Web Connection form validation object.
Added a new method UnbindFormVars() that's very similar to Request.FormVarsToObject() but differs in that it returns an collection of ValidationErrors message if there are binding errors.
These new methods return value settings that can be embedded in script expressions into Web controls for
checkedvalues effectively. These methods basically use a model value on GET requests or Request.Form() values on post backs to write out their values facilitating display of PostBack control state.
This method returns multiple uploaded files as a collection. This function support the
MULTIPLEattribute on the File Upload input control by accessing multiple files from a single form variable.
GetFormMultiple()but returns a collection instead of an array, to simplify working with the data more easily.
Request.aFormVars()but returns a collection of objects with
Response.ExpandScript() and Response.ExpandTemplate() Path Improvements
These two functions now allow using ~ in the path to specify the virtual root. Example:
Response.ExpandScript("~\views\login.wcs"). You can also call either function without a parameter and it will use the template that references the Physical path of the request.
wwProcessOnAuthenticated() and wwProcessOnShowAuthenticationForm()
Added additional features around authentication to make it easier to override the default authentication functionality. OnAuthenticated() is called when a user is authenticated either after logging in or after retrieving previous login information.OnShowAuthenticationForm() allows overriding the logic for displaying the authentication form so it's easy to hook in a custom form UI. The default form display now uses a customizable template so you might not have to modify code at all.
Hook methods that allow you to hook into the REST process call pipeline before and after a REST method is called. Allows modifying global parameters (like JsonServer.IsDebugMode) or examine and modify individual requests.
Flattens a multi-line SQL into a single line that FoxPro can execute at runtime using Macro expressions. Useful to allow you to write SQL with TEXT/ENDTEXT. Used internally in wwBusinessExecute and wwBusinessQuery.
wwUtils.IsNumber Returns .T. if the provided value is a number, or a string that contains only digists and decimal/seperators (. and ,). Useful in many data binding scenarios to determine validity of number input.
This function can be used to display binding errors for input controls. By providing a control id and ValidationError collection errors can be displayed explicitly in relation to the related parent control.
New HtmlPager() function that can be used to place a pager on the stage by specifying a page number, total pages and a base navigation URL.
New wwJsonServiceClient Wrapper Class for Calling API Services
This class provides an abstract
CallService()method that automatically handles JSON serialization of parameters, making the HTTP call, and deserializing the JSON result back into a FoxPro class. The method makes the HTTP calls and handles all errors.
Added a flag to automatically format all output from Serialize() to be pretty formatted. This is a post-processing operation, so it adds some additional overhead, but can provide a nicer development experience.
Web Connection .NET Module compiled in .NET 4.0
We've changed the compilation mode of the .NET Module to .NET 4.0 which means that if you are running with .NET 2.0 on your server you need to switch (and possibly install) .NET 4.0. .NET 4.x is the default installed version on most servers and desktops today and 4.0 is forward compatible with 4.5 and later versions which improves stability and performance.
Legacy wwPageResponse Methods Removed
The default response class used in new projects is the wwPageResponse class. This class has been trimmed down, and has removed all legacy functions that modified headers, generated cursors and others. It removes the
HtmlHeader()the various form control functions and more. If you are using an old application that uses these function you can switch to use the wwPageResponse40 class instead which is a subclass that includes all the legacy function. Override
wwProcess::cResponseClassand specify wwPageResponse40 and make sure you set the
#define INCLUDE_LEGACY_RESPONSEMETHODS .T.in wconnect_override.h.
wwProcess::nPageScriptMode Default Change
The default setting of
nPageScriptModewhich determines how non-method loose script files with a mapped extension are processed has changed. The new default value is 3 - Scripts which uses
Response.ExpandScript(). Other Values: 2 - Web Control Framework Pages, 1 - Templates (
wwProcess::ErrorMsg() requires an extra lcIcon Parameter
The ErrorMsg() function now receives an extra parameter to receive an Icon that is used from FontAwesome. If you are overriding the ErrorMsg() function in your own applications, make sure to add the extra parameter signature.
wwJsonSerializer::Serialize "cursor:TCursor" now returns a raw Array
wwJsonSerializer now serializes cursors that are created with
cursor:CursorNamesyntax to a straight array. Previously this generated an object with a
cursor_rawarray:CursorNamegenerated a raw array. The
cursor:CursorNamesyntax now has the same behavior as the
cursor_rawarray:CursorNamesyntax, which still works, but it is deprecated in favor of the shorter and more logic syntax.
wwSession Table Length changed to VarChar(17)
We've added a new wwSession unique ID generation algorithm that generates longer and random ids which requires a wider field. Also changed the Fox and SQL types to VarChar so the data is no longer returned with trailing spaces. To update delete wwSession.dbf and let it recreate. For SQL either change the ID field to varchar(17) and update the Sql Scripts to reflect the new width or re-run the SQL Server configuration script from the Console.
wwDotnetBridge default .NET Version changed to .NET 4
Changed the default version that wwDotnetBridge uses if no version is specified to Version 4.0 (which includes all 4.x versions including 4.5 and 4.6). If you want to use .NET 2.0 explicitly pass
CREATEOBJECT("wwDotnetBridge","V2"). We recommend you always specify your version explicitly anyway and remember only the first load determines the runtime loaded.
Comment or report problem with topic