Category: WINDEV

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 →

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 →

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 →