-
This Article will show you how to convert a C# or VB.NET Date/Time object
into an Internal MultiValue Date. It will show you how to do it using the
ICONV functions, and well as how to generate an Internal Date without
using the ICONV function.
Read More...
-
This article will show how to convert a MultiValue (PICK) Internal Date
into a DateTime object that you can use in C# and VB.NET. The article will
cover how use the OCONV statement, as well as, how to generate the DateTime
object without using the OCONV statement.
Read More...
-
The attached subroutine will convert a numeric values to their alphabetic
values. The number "4" converts to "four"; "25" converts to twenty five,
etc. There is also an option that will allow you to change a numeric value
into an alphabetic count. For example, 4 converts to "forth", "25" converts
to twenty-fifth.
Read More...
-
Some of your business processes are complex, some are simple. Let's look at
check writing as an example. This is a really simple process, but you can
run into one small snag.
Read More...
-
Reading and writing OS files is very important in the new hybrid systems we
have to write these days. Most of our applications are pretty
self-contained,and don't need to interact with programs or applications
outside the MV environment. But that is slowly changing.
Read More...
-
If you are migrating from another MultiValue system to Caché, an
introduction to some key terminology differences would be useful.
Read More...
-
The address is a key piece of information in anyone's database, but it can
be extremely hard to validate, and due to free form input, even harder to
search.
Read More...
-
These days we have to interact with other systems, which also means
interacting with other dates and times. UTC dates is a common date that we
run into, as well as RFC1123 dates, which are commonly found in web data.
Read More...
-
Log onto any MultiValue application that has been in existence for three
years, find a commonly used file, say CUST, and list it's dictionary. What
do you see? Definitions for LNAME, LAST.NAME, L.NAME, LST.NAME, LNAME40,
etc. Upon closer examination you discover that field (attribute) is also
defined as X, XX, PGM030.LNAME.RPT, and on and on. Log on to an application
that has been in use for 30 years and you could find several hundred
dictionary entries for a file with only 20 fields.
Read More...
-
When I ran across this blog post a month or so ago, I thought it was worth
republishing, as many of us have run into this one time or another.
Read More...
-
Interacting with delimited file structures for import and export is very
important within your enterprise software. Comma Separated Values format is
the most common.
Read More...
-
There are times when doing reports when you need to sort your values into
weeks. Most people would end up writing a program to do this, but that is
not necessary.
Read More...