Uncle Pete’s Corner – Edit in Place Table Control with Disabled Fields based on Logic

We are switching gears to WinDev this week, and a fairly simple requirement. Having an Edit-In-Place table that some of the controls are disabled based on logic. I know it sounds pretty straight forward, but there are a few gotchas that can get in your way at times, so we will take a look at … Continue reading Uncle Pete’s Corner – Edit in Place Table Control with Disabled Fields based on Logic →

Structured Arrays Primer – Part 2

We ran out of time last week when covering structured arrays. This week we will wrap up with Seeking on Structured arrays, some additional syntax that is available to use for structured arrays, and then get wild and crazy and talk about associative structured arrays. With a few more real world examples. After this week you … Continue reading Structured Arrays Primer – Part 2 →

Structured Arrays Primer – Part 1

I have a problem. And I hear the first step is admitting you have a problem. So you are my witnesses I am admitting I have a problem. So just what is this problem? pcSoft has turned me into an Array Junkie. It started off like all addictions do, I tried a few normal arrays … Continue reading Structured Arrays Primer – Part 1 →

Using XML to Store Options in Database instead of Individual Fields

We all have those projects where there is some dynamic portion that requires end user configuration. Those areas of the database always seem to be in churn because there is always one more field to add to control some aspect of the configuration. Or you have that project where the data you will be storing … Continue reading Using XML to Store Options in Database instead of Individual Fields →

TableToArray (Function to Copy Table Columns To Structured Array)

We had a memory table control based on an array and when adding a new row, we needed to move each column of the table into its corresponding structured array fields. Unfortunately TableSave only works with browsing table controls, so I had to create my own function to move each field. Well when I got … Continue reading TableToArray (Function to Copy Table Columns To Structured Array) →

Uncle Pete’s Corner – WebDev Looper With Break Header – FAQ Example

I recently had a client that needed a good example of a WebDev Looper that had a break header that used an Image to control the collapse and expansion of the breaks. So I dusted off my FAQ example I created a while back, upgraded it to WebDev 19, and documented all the code involved. … Continue reading Uncle Pete’s Corner – WebDev Looper With Break Header – FAQ Example →

Writing a URL Shortener with WebDev

At TeamAlogy.com we do data analytics for customer and team member engagement. As part of that process we send out survey request. Initially all of our request were going by email so it wasn't a big deal to embed this link http://www.teamalogy.com/Survey.awp?P1=TEST0F2D-DD0E-43ED-96F6-7914F15C1558 into the email. However now that we are starting to offer the survey request … Continue reading Writing a URL Shortener with WebDev →

Coming Attraction – Uncle Pete’s Corner – Writing a URL Shortener with WebDev

I wrote our own URL shortener service for TeamAlogy.com so now instead of sending this link in an email http://www.teamalogy.com/Survey.awp?P1=TEST0F2D-DD0E-43ED-96F6-7914F15C1558 we send this link http://www.teamalogy.com/ABO I started out researching Bitly and goo.gl to see about using one of them, but once I started the research I found out just how simple it is to build … Continue reading Coming Attraction – Uncle Pete’s Corner – Writing a URL Shortener with WebDev →

WD Container Column (Table Control) used as a Lookup Button

One of the challenges of using Combo boxes on Table Controls is that they can't be editable combo boxes, and the values allowed have to be the same for each row. Well of course I needed to be able to entered values other than what was in the list, as well as have a different … Continue reading WD Container Column (Table Control) used as a Lookup Button →

Validate Credit Card Number

Uncle Pete's Freebie of the day..... I need to validate the credit card number a user enters, so after some Googleing I came up with this function. It accepts the credit card number as a string then strips any spaces or dashes off. It then performs a few test to determine the card type, and … Continue reading Validate Credit Card Number →