Downloads

FUnit is a NUnit like utility for Unit Testing FoxPro applications. The developer write the test cases in the method that will be tested. The FUnit utility scans the application object modal searching for the test cases. Once found, they are extracted and executed. In addition, Code Coverage can be done as the tests are being executed. Therefore you can see what lines are being tested.

View the entire documentation on line at the FUnit - Unit Testing page.

The purpose of LifeCycle - Build Phase utility is to provide a central application to automated as much of the built process as possible without have to clone code, or replicate the procedure for different projects. It also provides the means to schedule automated builds for daily builds.

Overview

During any development cycle there is point when a project needs to be built into executables. There are different kinds of builds that can take place; the standard build done by the developer to build a local copy of the executables, the Debug or Test Build for the Testers, the Production Build to be distributed to the customers, and possibly many more other types between these builds. The purpose of LifeCycle – Build Phase utility is to provide a single place where all these different types of building processes can be created, maintained, and executed.

LifeCycle - Build Phase utility allows the developer and/or build manager to automate if not all, then most, of the tasks involved in building the pieces to run-time applications. The utility provides a list of all the projects in the overall project, and displays them in hierarchical listing based on dependency. But the main feature of the utility is the Build Styles. Each style is related to a list of Task steps, called the Build Script. The Scripts are performed during the build’s run process. Each of these tasks is a separate entity, which can be either added or removed from the build script at design-time. The build script tasks are creating as standard VFP Class Methods. No special PEM are required to identify the method as a build task, just a few extra comment line are required.

The LifeCycle – Build Phase Light version has a few limitations over the registered Professional version. But these limitation can be removed when the user purchase the Authentication Code that transforms the Light version into the full feature Professional version.

Click here to read more detailed information about LifeCycle – Build Phase.

Installation Instructions

1. Download the self-extracting ZIP file called lcBuild.exe from GLR software web site.
2. Execute the self-extracting ZIP file.
3. Accept all default settings.
4. Open any version of Visual FoxPro of version 6.0 or greater.
5. Change directory to C:\LifeCycle.
6. Perform "DO Demo"
7. When the Authentication Code dialog appears, click the "Skip" button.
8. Then you are in.

Versions

This is the finished release version of the LifeCycle - Build Phase utility version 1.0. If you downloaded the previous Beta version, please delete it before installing this version. Many features and construction of the utility has changed since the Beta release.

Build History

1.01.01 : (08/26/2005) : Build 544

• Slight refactoring of code to enhance startup speed and performance.
• Minor bug fixes.

• Loads and runs in VFP 6.0 correctly without C0000005 error.
• Correctly assigns valid value to MousePointer properties.
• Other minor adjustments.

Please send any comments, suggestion, or bug issues to LifeCycle@GLRsoftware.com

What's New in 2.0

More ways to generate the unique user code

• Hard Drive Volume Number
• Motherboard Serial Number
• User and Machine name
• Current Domain Name
• Company Name
• Logged On Server name
• User name only
• Computer name
• Network Card Number

12/19/2005
Included NameValue.prg in the zip file.

06/09/2006
Included missing files from the West Wind XMl class.

12/15/2005

Included classes that encapsulate the SysMetric(), FontMetric(), Home(), and OS() functions as named methods.

Have your clients ever ask to have their forms remember their position and size? This neat little control does just that. Now works with VFP 9.0 Anchors. Just drop it on any form, and it will remember its position and shape. The properties are saved in the registry for each user that can log on to the workstation. Now the settings can be either stored in the registry, a network table, or the local FoxUser resource file.

1.52 - fixed mis-spelled variable name - thanks Harry Nunn.

Loads multiple ProjectHooks into a single project manager, and maintain each as seperate classes and class libraries. This is great for when you have separate project hook classes, and like to use them all, but do not want to spend the time combining them into a single project hook. This zip file contents the pHook projecthook, plus all the projecthook in the following list. The demo project uses some of the project hooks as examples.

New to version 1.50
Add the Project Hook Manager form.
    -   Add new Project Hooks to the list.
    -   Remove Project Hooks from the list.
    -   Disable project hooks in the list.
    -   Help screen.
New project hooks:
    -   Switch to Project Orientated TaskList table.
    -   Strip printer info from Report forms.

New to vers 1.51
pHook.vcx
- Fixed QueryNewFile.
- Recurs the Activate and Deactivate events.
- Consolidate common code.
- Add Version property
phTaskList.vcx
- Switch Tasklist when more then one PM open.
ph_Manager.scx
- minor fixes.
- Regenerate PHL file only when something changes.

Version 1.60
- Moved the ph_Manager form into the pHook.vcx class library.
- Removed the ph_Manager Project and Application.

The following is a list of Project Hooks I have found while looking around the web. If you like to contribute your project hook, email it to Work@GLRsoftware.com. Include your name and email address, plus a short description of the purpose of the project hook.

Thank you, Greg.

Version 2.22 (VFP 9.0)

Yes, it's back.. But a new and improved version. Faster, Cleaner, and Extendable. I took a little time and rewrote the entire routine to allow the developers to add their own data drivers and cleaned up the code so I can better manage it (the first version became unmanageable.)

Query is a single function that allow you to manipulate various types of lists of data sources (Collections, Arrays, Cursor, XML data, delimited strings, and etc) with the standard SQL statements.

Use a standard SQL statement to filter, sort, combine data sources, and then convert to a different data source. Also, with the Update, Insert, and Delete SQL statement, you can manage the lists as if they were cursors.

Download it here.

Select from a Collection for items starting with "M" and output the sorted results to an Array.
TEXT TO lcSQL NOSHOW TEXTMERGE PRETEXT 15
SELECT * FROM Collection oColl
    WHERE left(name,1)="M"
    ORDER BY item
    INTO ARRAY laDest
ENDTEXT
lcnt = Query( lcSQL )

Get a list of files from a folder (and child folders) that have been modified after a specific date and place thier names (and paths) into a delimited string.
lcStr = ""
TEXT TO lcSQL NOSHOW TEXTMERGE PRETEXT 15
SELECT padr(alltrim(Path)+alltrim(Name),100) AS FileName
    FROM File ".\*.txt" Recur
    WHERE Modified >= {01/01/2009} and Archived
    ORDER BY FileName
    INTO String lcStr (comma,crlf}
ENDTEXT
lcnt = Query( lcSQL )

Update the Archived file attribute for a list of files in a delimited string (lcStr).
TEXT TO lcSQL NOSHOW TEXTMERGE PRETEXT 15
UPDATE file ".\*.*"
    SET Archived = .F.
    WHERE PADR(ALLTRIM(Path)+ALLTRIM(Name),100)
    IN (select * from String lcStr {comma,crlf})
ENDTEXT
lcnt = query( lcSQL )

Load a ListBox from a INI section. (These's a ComboBox version too.)
TEXT TO lcSQL NOSHOW TEXTMERGE PRETEXT 15
SELECT iniName, iniValue FROM INI ".\Test.INI"
    WHERE iniSection="Main" INTO ListBox oList
ENDTEXT
lcCnt = Query( lcSQL )

Delete a item from a INI file.
lcCnt = Query([DELETE FROM Ini ".\Test.INI" WHERE iniSection="Main" and iniName="SomeThing"] )

If you are interested in see this in action, you can download a copy here and run the Demo.prg program.

It was brought to my attention that the individual driver links were all broken. Some browser (or settings) were preventing the download of actual .PRG files. I have converted them to .ZIP format to fix the problem. Sorry. GLR

• Query.app (Internal)
• Driver Template: Base Query driver template. Used to create new drivers.
• Driver: Read and Write to Query Data Drivers informaton.
• General Visual FoxPro
• DLL: Read current DLLs loaded in FoxPro.
• Call Stack: Read VFP Execution Stack.
• Paths: Read various Paths.
• zip (VFP Program Info): Read Source Code (prg) using aProcInfo().
• Source Code: Reads zip source code as text.
• Variables
• Array: Read and Write to Arrays.
• Collection: Read and Write Collections
• Keyword: Read List of VFP Keywords.
• String: Read and Write Delimited String.
• Variable: Write output to a single variable.
• Set: Manage VFP SET commands.
• Objects
• Class Library: Read Only from Class Library using AVCXClass() function.
• ComboBox: Read and Write ComboBox items.
• ListBox: Read and Write ListBox items.
• PEM: Read Object's PEM information.
• Database
• Database: Read and Write to DBC Database Container
• Cursor: Read and Write to Standard VFP Cursors
• Field: Read and Write table structure
• IndexTag: Read and Write Table Index Tag information.
• ODBC: Read ODBC Data Source Information
• SQL: Read from SQL source via Connection String.
• Table: Read and Write standard Tables.
• Files and Folders
• File: Select,update,create,delete files for a folder. li>
• CSV: Read and Write CSV files
• XML: Read and Write XML Files
• External: Read and Write other file types (Excel,CSV,SDF,FoxBase,Fox2XDelimited)
• Computer Environment
• Drive: Read and Write to Hard Drive drives
• Environment: Read Only System Environment Variables
• Event Log: Read Only System Event Logs.
• File User: Read a list of filename and owners from network.
• Graphic: Read Graphic / Monitor matrix
• INI: Read and Write to INI files.
• Locale: Read System Locale information
• Network Resource: Read List using NetResource
• Printer: Read List of printers.
• System Processes: Read List of System Processes.
• Registry: Read and Write Registry Entries.
• Screen: Output various destination line Browse window, reports, etc.
• Window Services: Get a list of current windows services.
• Task: Read and Write System Tasks.
• User Groups: Read Security Group for Users.
• Users: Read list of logged in users.
• DSN: Reads registried DSN drivers.
• Time Zone: Read Time Zone information.
• Internet
• FTP: Read and Write from a FTP Site.
• RSS: Read RSS feed.
• Miscellanious
• Excel: Read and write from Excel.
• Outlook Contact List: Manage Outlook Contact list.
• Spell Check: Spell Check a string.
• Zip: Manage Zip files via vfpCompression.fll.


• Update Coming
• Simaphore: Manage windows semiphore.
• Active Directory: Manage Active Directory.
• AJAX: Read and write via an AJAX connection.
• ClipBoard: Manage windows Clipboard.
• DynaZip: Manage zip files using DynaZip.
• Font: Manage Windows Fonts.
• EmailCDO: Manage EMail via CDO.
• Message: Manage Message Queue.
• Outlook: Manage Outlook email.
• PrintJob: Manage windows Printer Spooler.
• WebService: Access Web Services.
• Window: Read windows Rectangle data.
• WMI: Generic WMI access.
• CursorAdapter: Access data source using CursorAdapter.
• Fax: Write to fax number.
• PDF: General result to a PDF file.

I am looking for any drivers you may have developed for the Query tool. If you have one or more or even an idea for one, please contact me at Query@GLRsoftware.com. Thank you. Greg