GLR software

Home

LifeCycle utilities

Updated since last visited.

Welcome
Welcome to the home page of GLR software. The site of all types software development needs. Come in and take a look around.

Query - Manage various types of lists with SQL

3/20/2008

Version 2.11

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 unmanagable.)

Query is a single function that allow you to manipulate various types of lists of data sources (Collections, Arrays, Cursor, XML data, delimitered 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.

? Query( [SELECT * FROM Collection oColl ]+;
[WHERE left(name,1)="M" ]+;
[ORDER BY item ]+;
[INTO ARRAY laDest] )

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

2.00.0049 -	Release of version 2.0
2.00.0056 -	Minor fixes
2.00.0129 -	Minor fixes and more drivers
2.00.0165 -	New driver
2.10.0207 -	Simplified driver interface, and now over 30 drivers
2.10.0208 -	Loaded current drivers into the APP, but it still will look for addition external drivers in the Data_Drivers folder. This make the tool better for distibution; the drivers do not have to be distibuted in the data_drivers folder.
2.10.0249 -	More drivers - 41 to count
2.11.0392 -	Minor fixes and File.prg is now optionally recursive.
2.11.0475 -	A few adjustments to some of the drivers, and new Windows Services driver.

Current Driver Types avaliable:
Hover mouse over blue keyword below for short definition.

Array
Class Library
Collection
CSV
Cursor
Database
Drive
Driver
Environment
Event Log
External

Field
File

FileUser
FTP
Graphic
IndexTag
INI
Keyword
ListBox

Locale
NetResource

ODBC
Path
PEM
Prg
Printer
Process
Registry
Screen
Service

Stack

String
Table
Task
UserGroups
Users
Variable
XML

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

FUnit - Unit Testing for VFP

12/11/2006

I would like to indroduce a new utility from the on going series of LifeCycle. FUnit is a NUnit like utility for unit testing and coverage analysis for object orientated applications. You write you test cases in the method that will be tested. Then run the FUnit utility. It will scan the application's object modal, looking for the test cases. When found, they get executed. The results are logged to a file.

You can read the entire users / development documentation online at the FUnit page.