GLR
 Software web site
10/8/2008
Visitor: 80791


 Home
 LifeCycle utilities
     Build
     FUnit

 Consulting Services
 Web Site Development
 Careers

 Articles
 Links & Resources
 Tips and Tricks
 User Comments

 Free Downloads

 About Us
 Pictures
 My Blog
 Contact Information
 Email Us
 Fun Stuff
 Email a Friend
 Google Analytics

 Add to Favorites
 Printer Friendly

  Updated since last visited.
 Now viewable in:
Microsoft IE ® 5.0+
Netscape ® 7.0+
Opera ® 7.54+
Mozilla FireFox ® 1.0+

Fox with Sheep


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.


 


Style:

Quote of the Day:
It is better to have and not need, then it is the need and not have.

Universal Thread







© 2003-2008   GLR Software - Gregory Lynn Reichert.    All rights reserved.