I took down the original page of links to my session materials that I posted for the RunRevLive 09 conference so I’m reposting the content here.
New Features and Bug Fixes
SQL Yoga 1.0.1 is now available for immediate download from the SQL Yoga site. The new version has a number of bug fixes as well as some new features.
Two new time-saving commands have been added to the library that will speed up creating and updating records:
Both of these commands allow you to pass in arrays with the values you want to insert/update in the database.
For a full list of changes please see the change log.
A new IDE plugin is now included with the SQL Yoga distribution. The plugin automates a few tasks and provides logging. You can read about how to install and use the plugin in the new plugin manual.
To learn more about SQL Yoga, download a demo or purchase please visit the SQL Yoga page.
RunRev is offering their MegaBundle sale again this year. This is your best chance to get all of the tools you need for a great price.
If you just need to renew your revEnterprise license or have been looking at developing software with Revolution this is the best price you are going to get.
All of our products that are available through RevSelect are included with the bundle: SQL Yoga, Professional Application Development with Revolution training courses and ScreenSteps standard.
UPDATE: This plugin has been replaced by the plugin that comes with the SQL Yoga distribution.
SQL Yoga automatically generates SQL for you so you don’t have to worry about it. Sometimes, however, it can be helpful to see the SQL that is being generated. Database objects have a couple of properties that can automatically log all generated SQL to a field or file.
The SQL Yoga Log Field plugin is simply a stack that registers a field as the field to log all statements to. When you want to see the SQL being generated by the default Database object simply open it from the plugins menu. When you are done just close it and all logging will stop.
Ivan Wong of MapleCommerce was kind enough to let me use an application he is working on as an example of how to convert an existing application to use the GLX Application Framework.
I just uploaded the new manual which I think will prove useful to those looking to start using the framework.
Additional Database Support
Blue Mango Learning Systems is pleased to announce that SQL Yoga now supports connections to local Valentina databases as well as client connections to Valentina Server. SQL Yoga now uses the powerful V4REV external under the hood to make working with Valentina easier than ever.
With the addition of support for Valentina local and client connections SQL Yoga now offers support for the following databases:
- SQL Server (ODBC)
- Valentina local and client
Why SQL Yoga?
SQL Yoga has redefined how developers work with databases in Revolution. It has done this by extending the simplicity of Revolution to databases by allowing you to treat your database like an object.
No more writing out SQL statements or working with cursors. Retrieving data is simple. You just set properties and then let SQL Yoga write the SQL, get data from the database, and convert it to a format you can use in fields or Data Grids. Updating data and creating new records is just as easy.
We have also been hard at work on the SQL Yoga documentation. We recently added a manual showing how to create a To-Do application with SQL Yoga. This manual is an in-depth tutorial showing how to create, update and delete records. It also shows how easy it is to retrieve data with SQL Yoga and display it in Data Grids.
Download Latest Version
To download the latest version of SQL Yoga and GET pricing information please visit the SQL Yoga web page. A demo version is available.
New Course Dates
Now that everyone at Blue Mango Learning Systems is back home and settled in after attending the RunRevLive conference in Edinburgh we are ready for another round of Professional Application Development with Revolution. This is our course that teaches you about application development techniques in Revolution. We start with how to organize your development environment and go through releasing installers and updaters. The course uses the open-source GLX Application Framework as a foundation to illustrate various principles.
The dates for the next course are September 29th and October 1st. There are two one-hour sessions each day.
We are also excited to announce that RunRev is sponsoring the first session of the 4-session course this time. This means you can attend Session I: Organizing For Success for free. In this session you learn how to set up your development environment so that you harness all of the benefits that Revolution offers when developing cross-platform applications. The focus will be on:
- Organizing your application development environment
- Understanding key concepts of the GLX Application Framework
- Maintaining a single code base when releasing to multiple target groups and platforms
- Organizing code, objects and internal media
SQL Yoga Discount
Those who purchase a course pass will also be eligible for 50% off the $199 price of SQL Yoga, the new database library from Blue Mango Learning Systems.
Learn more about the Professional Application Development With Revolution course and get pricing and registration information. Or, if you already know you want to attend the entire course, you can purchase a pass to the entire course now.
August 20, 2009 Update: A recording of the content covered in the webinar is now available.
Revolution is a powerful development tool because with it you can easily incorporate text, buttons, images, graphics and more into an application that runs cross-platform. You don’t need to understand the PNG image format or how Windows and Mac draw text on the screen. You just use Revolution’s english-like syntax to manipulate the objects in an easy to understand way.
Wouldn’t it be great if working with databases in your application were just as easy? With SQL Yoga it will be.
Join us, Blue Mango Learning Systems, for a webinar this Wednesday where we will show you the database library that will completely change how you work with databases in Revolution. Also learn how you can get involved in the public beta leading up to release at the end of September.
Register for the free webinar: https://www2.gotomeeting.com/register/490813635
Note: The webinar will be recorded and made available for viewing for those who cannot make it.
Have you ever wanted to display the grey text that describes what a text field does?
Placeholder text can be very useful as it provides a visual queue to the user about what the field does while not requiring any extra space in your UI.
Using custom properties and behaviors (new in Revolution 3.5) you can easily add this feature to fields in your applications. See the lesson How To Create Field Placeholder Text Using Behaviors.
Here is a teaser that talks about our upcoming webinar course on Professional Application Development With Revolution. Tomorrow (July 31st) is the last day for the Early Bird discount. We would love to see you there.