Learn More
Search site for:
News »
Scroll Up for Recent News
APPX 5.4.5 Available
APPX 5.4.5 is available for download from..

[Read Full Article]


APPX 5.4.4c Available
APPX 5.4.4c is available for download from..

[Read Full Article]


APPX 5.4.4 Available
APPX 5.4.4 is available for download from..

[Read Full Article]


APPX 5.4.3 Available
APPX 5.4.3 is available for download from..

[Read Full Article]


Amsterdam 2015 Conference Presentations available
We received some good feedback from the..

[Read Full Article]


CWI Announces Amsterdam Appx Training/Conference
We are pleased to announce an Appx Training..

[Read Full Article]


CWI Announces Appx Training
We are pleased to announce an Appx Training..

[Read Full Article]


Appx Software Announces New Price List Effective May 1, 2014
ASI has a price list effective May 1, 2014 ..

[Read Full Article]


Reconnect with Appx - Conference April 7-11
ASI has announced an upcoming conference April 7-11 in Atlanta...

[Read Full Article]


End of Support for 4.2.x Approaching
Due to the difficulty in supporting old releases and ...

[Read Full Article]


Amsterdam Presentations and Pictures Available!
We received some good feedback from the customers...

[Read Full Article]


Amsterdam Conference Registration Open!
Registration is now open for our Amsterdam Conference...

[Read Full Article]


Panama Conference A Success!
The Appx Conference held in Panama Feb 20-22 was well received...

[Read Full Article]


Panama Conference Registration Open!
Registration is now open for our Panama Conference...

[Read Full Article]


Appx Conferences in 2013!
Following the recent release of APPX 5.2, CWI is pleased to announce....

[Read Full Article]


Appx 5.2 Available
ASI has announced the availability of APPX release 5.2....

[Read Full Article]


Supported Releases
Release 5.1 of Appx is well on the way and ....

[Read Full Article]


APPX Conference Update
The Conference and Training session is over now....

[Read Full Article]


APPX 20th Birthday Celebration and Conference
ASI is pleased to announce the APPX 20th Birthday Celebration....

[Read Full Article]


Panama Conference in 2011
The Appx Release 5 Training and Conference was well attended...

[Read Full Article]


ASI Launches new Beta Progam
Appx Software, Inc has launched a new beta program ...

[Read Full Article]


Appx 5.0 Released!
The long awaited Release 5 of Appx is available ...

[Read Full Article]


Appx 5.0 Beta for Windows is Ready!
The Windows version of Appx Release 5.0 Beta is ready...

[Read Full Article]


Appx 5.0 Linux Beta is Ready!
Appx Release 5.0 Beta is ready. This Release includes ...

[Read Full Article]


Caylx Retires from Distribution
Following 33 years of working with the SPEED I, SPEED II and APPX...

[Read Full Article]


Appx Blog
Appx Blog Online
ASI has started a blog! This is an excellent way...

[Read Full Article]


Appx Conference 2007
We're pleased to report that our first European APPX Conference proved to be...

[Read Full Article]


Appx Conference 2007
Still haven't decided if the Appx Conference is for you? First of all, it's a great way...

[Read Full Article]


CWI Hosts European Conference
For some years now, ASI has been hosting tremendously successful APPX conferences in the USA...

[Read Full Article]


4.2.a Patch
ASI announces the APPX 4.2.a Patch Release is now available for download ...

[Read Full Article]


New Registration Format
ASI provides a new format for emailed APPX registrations. Registrations are now being sent as text file attachments to...

[Read Full Article]


Conference Results
Another conference is over, and once again it provided an excellent opportunity to network, learn and socialize with VARs and customers from around the world...

[Read Full Article]


Appx Conference
You are cordially invited to join your APPX colleagues and friends at the newest "episode" of the bi-annual conference, called "APPX EX-ZOO-BERATION 2006"!...

[Read Full Article]


Minicom Joins CWI
CWI is delighted to welcome Minicom Software House Ltda, located in Brazil, to its reseller network!

For over 25 years, Minicom's team of consultants has been involved in the development and...

[Read Full Article]


Sadden Joins CWI
Sadeen Computerized Systems is an integrated solutions provider which has been offering management control software, security systems and access control software to SMEs for a number of years. Now, however...

[Read Full Article]


SWS Joins CWI
CWI is pleased to welcome SWS Software Service in Austria to its reseller network! SWS has been a very successful SPEED II reseller since 1983 and has been working with APPX since...

[Read Full Article]


Sintec Joins CWI
CWI is pleased to welcome Sintec, S.A. de C.V. from Mexico to its reseller network!

[Read Full Article]


Scroll Down for Archived News


A | B | C | D | E |F | G | H | I | J | K | L | M | N | O | P
Q | R | S | T | U | V | W | X | Y | Z


Regular Expressions

In one of the recent releases of APPX, support for Regular expressions was introduced. It was primarily added because it was required by the 0-apps, but we can use it in our own applications. What is a `Regular Expression'? The Wikipedia encyclopedia defines it as "A regular expression (abbreviated as regexp, regex or regxp, with plural forms regexps, regexes or regexen) is a string that describes or matches a set of strings, according to certain syntax rules. Regular expressions are used by many text editors and utilities to search and manipulate bodies of text based on certain patterns. Many programming languages support regular expressions for string manipulation." A full explanation of Regex would take more space than we have available, so we'll just give a few examples and some pointers on where you can get more information.

The Regex operators can be used in an IF, OR or AND statement, in place of the usual EQ, NE, GE, etc. You can also use them in the End User and Designer selections of Queries. There are two operators, RS and RI. RS uses case sensitive matching and RI uses case insensitive matching (tip: S-Sensitive, I-Insensitive).

A simple example: to find all names that match `Cansys', regardless of how it is capitalised, we could use a Record Selection of `RI' `cansys'. Since it is case insensitive, it will match `Cansys',`cANSYS', `CaNsYs', etc. To find all names that begin with A, F or G we would use `RS' `^(A|F|G).*'. This expression means find anything beginning with A or F or G (the `^(A|F|G)'), followed by any character (the period), followed by zero or more occurrences of the previous character (the asterisk). If we omitted the period, the asterisk would apply to the ^(A|F|G), and would mean `anything starting with zero or more occurrences of (A|F|G), which would be everything. If we left out the ^ it would mean match A, F or G anywhere in the string. If we wanted to find names regardless of upper or lower case, we would use the `RI' operator instead of the `RS' operator.

As you can see, the syntax for regular expressions can be difficult to get right. A Regular Expression with syntax errors will result in an `Overflow Error' at runtime. There are a number of different implementations of Regex - APPX uses the GNU Regex library.

For more information on Regular Expressions, try a Google search on `What is a regular expression'. They can be tricky to figure out but they can be extremely useful and it's worth the effort.


Remote Command Execution

In the Windows environment copying files from one folder to another folder on the server can be network intensive and slow if you do it from a workstation on the network. This is because the data has to be sent to your workstation, which promptly sends it back to the server. Ideally, it would be best if you could perform the copy directly on the server, however, in some situations the server is physically secured, and you don't have access to it. This tip shows a technique that allows you to enter commands on your workstation that are executed directly on the server.


Removing Records from a Constrained Scrolling Display

We have found that you can remove a record from a scrolling, constrained display when it no longer meets the constraint by performing a READ with HOLD on the record, and setting OPTION to NEXT RECORD in the option intercept event point. For example, if you have list of Orders constrained by Order Status displayed, and you allow the operator to change the status via an Option key that you intercept yourself, it would be nice if APPX would make the record disappear from the display once your code changes the Order Status, since it no longer meets the constraint. The usual method is to end the process and reinvoke it, causing APPX to refresh the display. There are 2 problems with this, the display starts from the beginning of the file, causing the operator to manually find their position, and it gets complicated if your Input process is invoked from more than one place with different constraints or default keys (you have to keep track of where you came from so you know how to reinvoke the process). By setting Option to NEXT RECORD, APPX will reread the records surrounding the one it was on, and discard the one that doesn't meet the constraint. Presto, the record disappears!

Note that if you issue an ERROR, WARNING or even a MESSAGE command at the same time as you set OPTION = NEXT RECORD, this will not work.





For additional information, contact tips@cwi-appx.com

[back to top]