Gone to wxDevCon

Leaving in the morning to head to the WxDevCon in Nashville, TN and be ready to present from Novemeber 7-11,2012. Looking forward to seeing lots of old friends and making some new ones. Hope to see everyone there. Once I return I will be working on finishing the documentation and sample application for the BSD3 … Continue reading Gone to wxDevCon →

Custom Report Breaks and Totaling without all the Hand Code

Photo by sure2talk I covered Hand Coded WinDev reports in a previous article, now we are going to extend that with custom level breaking and sub-totaling. Don't worry, even though the report is "Hand-Coded" all of the standard tools are still available, no need to completely hand code just because you have to do some hand … Continue reading Custom Report Breaks and Totaling without all the Hand Code →

Hand Coded WinDev Reports

After my series of Webinars on Reports, for the upcoming wxDevCon, I have had several developers ask about about techniques for Reports in WinDev. Hand coded reports is always one of the top questions, so this is a quick overview of the process to do a hand coded report in WinDev. First don't rush to … Continue reading Hand Coded WinDev Reports →

Calculating the 2nd Tuesday of the Month

As many of you know I am in the middle of rewriting pcReminder.com from Cold Fusion to WebDev. Since it is a reminder site, a lot of the functionality revolves around dates. For instance one of the features we support is scheduling a reminder for the nth weekday of the month, such as the 2nd … Continue reading Calculating the 2nd Tuesday of the Month →

Getting the Light Bulb to Click on with Data Abstraction and OOP

Those of you that have followed me for years, know I am a bit of an Old School Guy. But with WinDev I have finally seen the light and am starting to do more and more class coding. Those classes have been what I would call utility classes, they managed bits of the UI (like … Continue reading Getting the Light Bulb to Click on with Data Abstraction and OOP →

What did I do Today?

We have a display program similar to the display in airports. We constantly have request from customers that want it customized or they end up creating their own. I decided the best way to handle it was create a group of functions in SQL Server to do all of the logic of what to display and how … Continue reading What did I do Today? →

Auto Incrementing with PostgreSQL and Windev (Updated 10/3/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.