PostgreSQL Case Sensitivity Part 1 (The DDL)

Anytime you discuss PostgreSQL, the issue of case sensitivity quickly boils to the top of the conversation. Having used PostgreSQL in several high volume production systems for the last 3 years I will attempt to seperate some of the myth and legend out of the conversation and provide some best practices methods that have worked for me.

PostgreSQL Images with WinDev – Update 12/21/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 →