2012

If you want to store images in your postgreSQL database and display them directly in a WinDev image control, Then you need to configure your database to return the bytea format as 'Escape' instead of Hex. With V9 of PostgreSQL the default changed to Hex and apparently pcSoft has not caught up with the new … Continue reading PostgreSQL Images with WinDev – Update 12/21/2012 →

5 Minute Demo Video Showing Dynamic Selection Browse and Intelligent lookup fields

5 minute video showing a dynamic lookup using some of the techniques for dynamic browses from Glenn Rathke's training class. If you type in a valid branch code, it links it up and your done If you type in a partial name instead then it does a like statement to find matching records, if it … Continue reading 5 Minute Demo Video Showing Dynamic Selection Browse and Intelligent lookup fields →

Uncle Pete Presenting at WxDevCon 2012

I am very excited to be presenting at the WxDevCon in Nashville, TN - Novemeber 7-11,2012. This is a very unique format that include over the should developer session between now and the event, and the source code for an entire suite of applications that we will be building for the non profit sector … Continue reading Uncle Pete Presenting at WxDevCon 2012 →

HotKey on a Window

My application has a "hidden" hotkey that opens up a special User Activity screen anytime the user presses Control F12, while on the main menu. In clarion I did this by setting an alert key for the window, then in the Events.AlertKey embed point I tested to see if the Control F12 was pressed and … Continue reading HotKey on a Window →

Database Field as Text

When I want to display a database field as text (not an entry field) I've been creating a static control and then to setting the value in the code by doing something similar to: STC_Field = MyTableField Then I remembered "If it seems hard, you are probably doing it wrong!" and decided that style system … Continue reading Database Field as Text →

TableSelectPlus

It easy to select a specific row of a table control with TableSelectPlus, but any code in the "Row Selection" process will not be executed. Read on to see how to make your code fire.

NumToString

Since WX treats screen controls as strings (including columns of a table) Trace(NumToString(COL_HstInvHdrSysId,"012d")) does not work. You don't get an error, it just doesn't do anything because it's not a number. So if COL_HstInvHdrSysId contains 123456 the result will be 123456. instead you have to do: nHstInvHdrSysId is int = COL_HstInvHdrSysId Trace(NumToString(nHstInvHdrSysId,"012d")) Now you will … Continue reading NumToString →

Spending a Day with Windows 8 and Visual Studio 11 Betas

Photo by simply.jessi I spent yesterday at .Net developers conference (or behind the walls of the evil empire). The workshop I attended was an introduction to developing business applications for Windows 8 Metro using Visual Studio 11. Read on for my take away from the workshop Let me start by saying I am a 4/5 GL developer and … Continue reading Spending a Day with Windows 8 and Visual Studio 11 Betas →

Issues with Storing Window Position With Multiple Monitors

Photo by SOYBEANTOWN While working on the Document Viewer Component I ran into a few issues with the standard WinDev window position restore logic with dual monitors, so I created a couple global procedure to work around the issues. WinDev will save the size and position of each window in your application. This allows end users … Continue reading Issues with Storing Window Position With Multiple Monitors →

Improving SEO with Dynamic Content Using Server Side Includes and PHP

In case you have been living under a rock, SEO (Search Engine Optimization) is a very important topic for any website. Having fresh content is a powerful method of improving SEO, such as adding a list of the most recent 5 blob post to your home page. With a few simple changes to your Apache Config files, you can uses Server Side Includes to run PHP code snippets inside your standard HTML files. Why would I want to do that? My main website (http://www.thenextage.com) is a simple HTML website that I maintain with Dreamweaver. Instead of converting the site to PHP or WebDev, I wanted to keep the site simple and easy to maintain. This article will explain how I am mixing PHP code into standard HTML files