Category: WX

2012)

Photo by bling_rocks There are a few challenges when attempting to use auto-incrementing keys with PostgreSQL and Windev. But once we understand what the issues are, its easy enough to work around. PostgreSQL uses sequences to accomplish auto auto-incrementing fields, for those that normally work with SQL Server this is a little different than the Identity Columns of SQL Server. … Continue reading Auto Incrementing with PostgreSQL and Windev (Updated 10/3/2012) →

Using the ..Note Property

I was going through some of the WD unit examples this morning looking for inspiration. I really suggest you do this from time to time, there are lots of great examples there, and as you knowledge of WinDev grows, more and more of the examples will apply to you. Here's a cool tip I found … Continue reading Using the ..Note Property →

PostgreSQL Case Sensitivity Part 2 (The Data)

In part one we covered Case Sensitivity of the Data Definition Language (DDL), in part two we will move on to the data itself and once again examine some best practices that have worked for me.

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.