Category: WX

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 →

HF SQL Doesn’t support complex Update Statements

As many of you know I have been slowly become more of a convert to HyperFileSQL and WX Queries. And generally use HF for my projects while they are in the R&D stage, only moving them to PostgreSQL if they are going to involve very large/complex data sets. Or if the client requires some other … Continue reading HF SQL Doesn’t support complex Update Statements →

Multi Language option at Login

When asked about developing multiple language applications, I have always made the wise crack: "Once I sell every English speaking person a copy of my software, then I will worry about translating it to another language" Well now that I am consulting on projects in Europe and other spots around the globe, I am seeing … Continue reading Multi Language option at Login →

PDF Viewer/Scanner/Importer Screen with Database Storage

This week's Uncle Pete's corner will be looking at my PDF Viewer/Scanner/Importer Screen. We will be storing the images in a Hyperfile C/S database. This will be 100% native WinDev code no ActiveX or .NET required! One of my very early projects involved document storage. That was a long time ago! The documents weren't stored … Continue reading PDF Viewer/Scanner/Importer Screen with Database Storage →