Using ILE RPG's /COPY with embedded SQL

ILE RPG's compiler /COPY directive can be troublesome when an included member defines SQL host structures. Here's how to fix the problem.

Clearing controls on AVR for .NET's Windows' Forms

Unlike AVR Classic's Clear opcode, AVR for .NET's, Clear opcode cannot be used to clear a form. This article provides a solution to that challenge. This challenge is packed with ah-ha moments, especially for those of you coming to AVR for .NET from AVR Classic.

How to stretch ASP.NET session timeout

Hardcoded session timeouts don't always resolve your ASP.NET challenges. This article shows you how to combine the advantages of a long session timeout with the benefits of quick user job cleanup.

Using FTP to send and receive IBM i source members

This article shows how to use Windows intrinsic FTP client to send or receive a source member from/to your Windows PC and the IBM i.

Dispose of objects effectively with AVR's BegUsing operation

An often-overlooked ASNA Visual RPG (AVR) feature is its BegUsing operation. This operation provides a streamlined way to dispose of objects.

Using .NET's data structures with AVR: The generic stack

.NET stacks, queues, lists, dictionaries, hash tables, and collections offer a nearly endless way of working with your data.

Working with numeric dates in AVR for .NET

Working with dates is something many RPG programs do extensively. In the old days of AVR Classic, we used to have to use lots of data structures and other special-case code to format dates, convert dates. It was also quite challenging to do date arithmetic and perform other sophisticated date manipulations. AVR for .NET's *Date, *Time, and *TimeStamp help resolve all of these issues. However, many shops still store dates (and times) as numeric values in their database. This seems to preclude using some of .NET's really great date handling and manipulation. This article changes that and shows how to integrate your numeric date and time values with .NET's great date and time handling.

Using regular expression character classes and quantifiers

This article shows how to use regular expression character classes and quantifiers with ASNA Visual RPG. This is part 2 in a series.

Starting the Visual Studio command prompt

The Visual Studio command prompt is hard to find in Windows 8 and 10. This article shows how to resolve that challenge.

An introduction to regular expressions with ASNA Visual RPG

Regular expressions (regex) provide a pattern matching scheme you can use to search and, optionally manipulate, a string. Although regex has been around for almost 50 years, it is often either completely ignored or relegated to the "will learn later" pile by many programmers. This article, the first in a series, introduces you to using regular expressions with ASNA Visual RPG.

How to create/install custom ASNA Visual RPG project templates

ASNA Visual RPG for .NET (AVR) comes with many project templates. The templates provided are generally serviceable, but wouldn't it be handy to be able to create your own templates? This way each time you start a new project it's got just the things you want, the basic forms you need, and all the extra goodies you usually use. And wouldn't it be nice to make many of those suit your different application challenges! Read on, this article shows you how.

Demo Web and mobile apps without deploying them. Now!

One of the frustrations of writing Web or mobile applications is that before you can demo them you must deploy them. For many apps, deployment takes nearly as much work as writing them! Imagine having an ASNA Visual RPG Web app, or an ASNA Mobile RPG app, in Visual Studio on your desktop and, in about 20 seconds, being able to show it to anyone, anywhere, on the Internet. Without deploying it!