Tuesday, 3 April 2018

Stadium v.4.2.2840.6182 is available

Stadium 4.2.2840.6182 is available for download from the Twenty57 website. It contains the following bug fixes:
  • Fixed serverside dropdown issues (#3152)
  • RDLViewer Component not working (#3150)
  • Details View Date Control (#3181)

Monday, 5 March 2018

Stadium 4.2.2839.6178 is available

Stadium 4.2.2839.6178 is available for download from the Twenty57 website. It contains the following bug fixes:
  • Fixed serverside dropdown issues (#3084)

Wednesday, 31 January 2018

Stadium 5.9.2074.6587 is now available

In this release, we redesigned the entire Event Framework from scratch! This new, greatly enhanced, more powerful and easy to use Event Framework gives you the freedom you need to design highly interactive applications, making your users' experience so much better. Please give it a test run and let me know what you think!

The important new features I want to draw your attention to are:
  • Events

    A powerful event framework allowing designers to greatly enhance the interactivity and user experience of their applications. PageLoad and OnChange were added as two new events with more to come in the future!
  • List controls now use JSON formatted data

    DropDown, RadioButtonList and CheckBoxList now use JSON formatted data when specifying static options. By doing this, options can now be re-used simply by reading them from a Static Data file or copy pasting them from one control to another.
  • Static Data

    Include files & images as static data into your Stadium application and use them on certain controls and actions.
  • Selectable Rows in a DataGrid

    The DataGrid now has an optional checkbox column allowing the user to select one or more of the rows inside of the DataGrid. The application designer can then iterate through the selected rows using a ForEach action in a script.
  • Get or set the search term of the DataGrid

    Being able to get or set the searchterm is very useful when navigating away or back to a page where the DataGrid should remember the user's previous search.

Other features and bug fixes we worked on can be seen below.

Features

  • Database column type, HierachyId, is now supported
  • Expanding the DropDown on the canvas should also select the control
  • In the generated application, do not allow the current user to be deselected as Administrator
  • Add messages to empty tables in the Admin site
  • On the canvas, indicate invisible columns by displaying their text as light gray
  • Prevent possible security attacks on the generated application(i.e. Clickjacking, XSS)
  • Infer types assigned to properties
  • Allow selecting Connectors as Value for the SetValue action
  • Allow assigning references to the Message property of the Notification Action
  • Improve the performance of the Gallery Editor
  • Allow get and set for the Options property on list controls via scripts
  • Do not delete actions inside of the current Button paths when changing the Buttons of a DisplayMessageBox
  • Changes around setting and deleting of the Application Start Page
  • Toastr error messages thrown by Stadium should be explicitly dismissed by the user
  • Database connection validation not disappearing after correcting it
  • Remove the option to assign Control properties to the NavigateToPage.Destination property
  • Use the ~ to represent the script in a reference breadcrumb
  • The Tables & Views pane of a query should be open by default
  • Rename DataSources to Connectors
  • ConnectionString editor loses focus when testing a connection
  • Add a '+' icon to DataSource node in the App Explorer to add new queries
  • Rename the ForEach loop variable
  • Provide an indication to the user when there are script errors

Bug Fixes

  • Connecting to SQL Server via ODBC fails
  • InstallTools folder should not be installed when installing Stadium
  • Copying a page does not restore references to corresponding controls
  • Adding a LayoutTable to the page causes an ObjectReference error
  • CallScript action used in an EventHandler causes ObjectReference error on Generation
  • Gallery gets hidden behind Main Window of Designer when adding new images
  • After the FormWizard exits, the focus in the App Explorer should be on the newly added page
  • Right clicking on the tab of a canvas, closes the canvas
  • Validation issues on Page Parameter, Script Input Parameter and Script Output Parameter editors
  • Hover and selection issues of controls inside of a LayoutGrid
  • DataGrid alignment is off on the page canvas
  • Deleting a folder should close any open tabs of deleted items
  • Designer Window/Pane Layout does not persist unless application is saved
  • Changing access requires the affected user to log out and log back in again before it takes effect
  • Uninstall completes but does not remove Stadium
  • Double clicking an image in the Image Gallery does not select and assign it to the Image Control
  • The ReferenceComboBox does not persist changes on blur
  • Strange behaviour during setting the data of a DataGrid using SetValue
  • An ExecuteSqlCommmand action using session variables as parameters inside of an event script on a template causes a generation exception
  • All panes except the Toolbox freeze up if the Toolbox is clicked while a context menu is open
  • Ordering of pages is incorrect when renaming a page
  • The icon next to the 'New Query' item in the Database context menu is missing
  • When generation fails, the failed build overwrites the working website
  • An @ symbol in an Expression causes a script error
  • Copying Container controls containing other Container controls causes naming issues
  • EventHandler "Copy to script" functionality causes errors when saving the application

Monday, 29 January 2018

Stadium 4.2.2838.6169 is now available

Stadium 4.2.2838.6169 is available for download from the Twenty57 website. It contains the following bug fixes:
  • Filter is Executing DataGrid Query prior to apply (#3014)

Monday, 18 December 2017

The Year in Review and Our Plans for 2018

As this year comes to a close, we at Stadium wanted to reflect on the year that has been, and look forward to the year ahead. Most importantly, we want to thank you, our users, for trusting us to meet your development needs and look forward to working with you in 2018.

A year ago we had spreadsheets full of goals and we’re proud to say we knocked (most of) them out of the park. Thank you for making 2017 unforgettable.

In 2017, we were proud to bring you

  • Direct Page-Script interaction

    Being able to access page controls directly from inside scripts allows for simplified and more powerful scripting.
  • Session Variables: Logged-in user information

    Basic information of the logged-in user can now be used in the application.
  • User REST Web Api

    Basic management of the Stadium users in generated applications.
  • Simplified query creation

    Use the Tables & Views Pane to quickly and easily generate queries for specific tables or views. Also use this pane to see what tables and columns are available in your database while writing your query.
  • Expressions

    Build expressions by using a combination of javascript and application values and then assign the result of the expression to either controls or actions.

What’s in store for 2018!?

We are already planning some exciting updates, including more features, updates to the UI and a further streamlined experience including a new website.
  • Events

    PageLoad and OnChange are some of the many other events we will be introducing. This will allow designers to greatly enhance the interactivity and the user experience of applications built with Stadium.
  • Static Data

    Include files & images as static data into your Stadium application and use them in controls and actions.
  • Stadium Server

    The Stadium Server will allow deploying applications to remote servers as well as managing your already generated applications.
  • File System DataSource

    A DataSource that will allow you to access your filesystem.
  • WebService DataSource

    This DataSource will allow you to invoke and use a WebService like you would a database.

Lastly, we want to implement the great feedback you are giving us - so please continue to let us know what you’re working on and never be shy to suggest new features and improvements.

It’s been a year of highs and lows, but one thing is certain: all of us at Stadium are proud of what we and our users have accomplished in the past year. Your work is the reason why we come to work everyday. We are dedicated to bring your ideas, your creativity, and your businesses to life on the web - and we couldn’t do it without you.

Happy holidays

The Stadium team

Tuesday, 28 November 2017

Stadium 4.2.2836.6165 is now available

Stadium 4.2.2836.6165 is available for download from the Twenty57 website. It contains the following bug fixes:
  • RDL Report Viewer fails to expand rows (#2938)
  • IsExportable on Links does not work (#2887)
  • Changes to Stadium Concurrent Login (#2873)

Friday, 20 October 2017

Stadium 5.8.1985.6160 is now available

We are releasing our first version of the Web Api that will simplify integrating the user database with other systems. On top of this, there are many other added features and improvements.

The features I want to draw your attention to in this version are:
  • Web Api

    Access and manage users of generated applications via a REST web api. To see more on this, generate an application and visit the API menu of the Admin section in the browser.
  • More powerful Image control

    The image control can now display images straight from a database or get an url to an image using datasources, settings, page parameters or expressions. Best of all, the control can be accessed from inside of a script allowing you to dynamically change which image is displayed without the need to renavigate to the page.
  • 'Google-like' file upload

    Upload multiple files at once by selecting them from a file selector or by dragging them straight into the box. They will immediately start uploading without the need to press the upload button.
  • New action: Call script

    Call other scripts from within a script. You now have the ability to break big unwieldy scripts into smaller more concise scripts and invoke them when needed. Creating smaller scripts leads to more readable and understandable applications as they grow bigger.
  • Improvements to the Tables & Views pane of a Query

    Quickly generate CRUD queries by making use of our generator. Do this by right clicking on a table or view and choosing between a Select, Insert, Update or Delete statement. Changes have also been made to enhance both usability and the performance of this pane.
  • Lists can now be set using JSON

    The items for any list control, i.e. CheckBoxList, RadioButtonList or Dropdown, can now be set by assigning a JSON object to the Options property. This simplifies reuse of lists across controls.
  • More wide-spread use of expressions on actions

    Expressions proved to be so useful on the SetValue action, that we decided to make them available to all actions.

Please download this latest version and let us know what you think! Other added features and bug fixes are listed below.

Features

  • Allow a Query to execute CREATE PROCEDURE
  • All controls should have a Visible Property
  • Change email to be the username of a user
  • SetValue should allow column mapping when setting DataGrid.Data
  • Allow assigning a query with output parameters to a control or action
  • Connections and Queries: Always test/execute through the service in the Designer
  • In the Menu Control: Order the pagenames in the Destination Page dropdown of the MenuItem
  • Change all boolean values from True/False to true/false
  • Remove the .NET Framework 3.5 dependency

Bug

  • DataGrid search fails when searching for dates
  • Pasting an action should select that action afterwards
  • Do not allow tabbing into the texbox on the canvas
  • Controls should be highlighted when their properties show
  • Oracle should allow defining parameters with @
  • A control cannot be dragged onto the canvas immediately after creating a new application
  • Application Explorer loses focus after selecting a page, script, template, query or stored procedure
  • No-typing ReferenceCombobox does not grab focus when dropped down
  • ReferenceComboBox incorrectly changes the property description on the PropertyGrid
  • Fonts missing from themes folders
  • Uninstall does not remove Stadium from the StartMenu of Windows
  • ODBC and Oracle render illegal column names
  • Control loses focus after moving it on the canvas
  • Edge reports 404 when fetching the generateSourceMap file
  • Float icon overlaps tab when making the pane very narrow
  • DataGridColumn renames header text when changing
  • DataGridColumns across separate DataGrids can be selected simultaneously
  • Tab stops with parameters in the Property Grid are incorrect
  • Error page image is being cut-off
  • Validations DropDown in the Property Grid allows moving through items with up and down arrows
  • AutoMapping of fields for MySQL does not happen
  • Horizontal Scrollbar is in the middle of the dropdown of the ReferenceComboBox
  • Admin section does not populate the Page property on the Access Denied error page
  • When all submenu items are unaccessible, hide the top level item
  • Executing a stored proc via a query lists the parameters of the stored proc as parameters to the query
  • DataSource toolbar menu does not highlight the submenu hovering over
  • Tab order is not correct for the properties of the TextBox
  • When opening the Stadium Designer, an exception is thrown if access is denied to the pc's environment properties
  • Exception thrown when pasting an action on the page canvas
  • The latest styles and scripts are not used on applications created on Stadium 5.7 and then upgraded to Stadium 5.8
  • When dragging a table, view or column into a query below the sql text, a No-entry icon is shown
  • Do not ask to remember the password when creating a windows authenticated admin user
  • Prevent update queries being assigned as datasource for datagrids
  • Property dropdown does not close when tabbing between programs
  • Cannot call methods on References in the Expression Editor
  • Tables & Views cannot be retrieved for example database, Wide Wolrd Importers
  • Update PropertyGrid when adding or removing MenuItems on the canvas
  • Image on the ErrorPage jumps to the left of the text at a certain width
  • Do not allow Expressions on control properties
  • DataGrid column not updating property grid when Database was selected
  • ReferenceComboBox throws NullReferenceException in certain scenarios
  • The Help file menu remains highlighted after the dialog closes
  • DataGrid did not resolve fields correctly with spaces in the name
  • 'Internal Server Error' exception occurs when testing the database connection