Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Add
Search: 
Search

Query 2.22 - Query (SQL) just about anything.
Greg Reichert, GLR Software
Image be able to manage an array (or any list of data) using a SQL statements. Well with this little tool you can. Query allows you to select, update, delete, and even insert data into array, collection, cursors, file directories, most any list of data. And it can be extended too. Yes; you can create your own data drivers to most any source of data. Now with over 50 data drivers
Created on
17 years ago
Downloads
2193
File type
Freeware
Rating
5.00/5.00
General information
URL:
http://www.glrsoftware.com/download/download.asp?file=Query.zip
Rating:
5.00/5.00 (1 rate) Rate this item
Description
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. Build History     * 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 distribution; the drivers do not have to be distributed 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.     * 2.22.0843 - More drivers. In list below, you can now download individual drivers as they become available or updated. The driver may have icons to indicate wheither the driver is New (New), recently Updated (Upd), or currently under development (Dev). Updated and New icon will disappear when new releases of the Query tool are uploaded. 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. Upd     * 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. New     * 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. Upd     * 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. Upd     * Locale: Read System Locale information Upd     * 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. Upd     * 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. Dev
  • Miscellanious
    •     * Excel: Read and write from Excel.     * Outlook Contact List: Manage Outlook Contact list. Dev     * Spell Check: Spell Check a string.     * Zip: Manage Zip files via vfpCompression.fll.
  • Update Coming
    •     * Simaphore: Manage windows semiphore. Dev     * Active Directory: Manage Active Directory. Dev     * AJAX: Read and write via an AJAX connection. Dev     * ClipBoard: Manage windows Clipboard. Dev     * DynaZip: Manage zip files using DynaZip. Dev     * Font: Manage Windows Fonts. Dev     * EmailCDO: Manage EMail via CDO. Dev     * Message: Manage Message Queue. Dev     * Outlook: Manage Outlook email. Dev     * PrintJob: Manage windows Printer Spooler. Dev     * WebService: Access Web Services. Dev     * Window: Read windows Rectangle data. Dev     * WMI: Generic WMI access. Dev     * CursorAdapter: Access data source using CursorAdapter. Dev     * Fax: Write to fax number. Dev     * PDF: General result to a PDF file. Dev
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
Created by
Greg Reichert, GLR Software

Comments
I simply canot download any drivers, it gives me a 404 error (Page cannot be found). Rignt now i'm using Google Chrome, but i remember having the same issue with Firefox when i tried downloading the drivers from your site .. Please fix this. Eduard Alexandru, April 21, 2009

Add a comment
More downloads created from this member
FUnit - Unit Testing for VFP
Greg Reichert, GLR Software
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...
Created on
17 years ago
Downloads
538
File type
Freeware
Rating
5.00/5.00
Auto close forms after N seconds of inactivity
Greg Reichert, GLR Software
Automatally closes a form after N seconds of inactivity from the user. Based on Timer class and monitors the current position of the cursor and mouse. Just drop the control on any form, and set the desired duration of the delay.
Created on
18 years ago
Downloads
2154
File type
Freeware
LifeCycle - Build Phase utility - version 1.01
Greg Reichert, GLR Software
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. The util...
Created on
18 years ago
Downloads
598
File type
Freeware
AuthCode - Authentication Code - ver. 2.02
Greg Reichert, GLR Software
AuthCode, or Authentication Code, is an add-on form that makes the application into an evaluation copy type. The user can use the application until either an expiration date or count runs out, or they have registered it by entering an authentication code. At which time the application will stop aski...
Created on
19 years ago
Downloads
2562
File type
Freeware
Rating
4.00/5.00
Encapsulate the SYS() and SET() as methods
Greg Reichert, GLR Software
This object encapsulates the SYS() and SET() functions in methods of a class. This allows the developer to use these function by named instead of sum number. Plus it provides more readability of the source code. 12/15/2005: Included classes the encapsulate the SysMetric(), FontMetric(), Home(), and ...
Created on
19 years ago
Downloads
894
File type
Freeware
Auto resize controls on any form
Greg Reichert, GLR Software
This tiny control resizes controls on forms. Just drop this control on any form. Set the TAG properties of the controls you wish to resize to a combination of T,L,H,W. And place a Thisform.Refresh() statement in the form's Resize event. That is all there is to it. Now work properly in VFP 6.0.
Created on
19 years ago
Downloads
2506
File type
Freeware
Loading Multiple ProjectHooks - vers 1.51
Greg Reichert, GLR Software
Multiple Project Hooks is a ProjectHook class that allow for chaining more then one projecthook class per project manager. If you have different projecthook class that do different tasks, and you want then all to be a part of the current project you are working on, you normally would have to combin...
Created on
19 years ago
Downloads
627
File type
Freeware
Shell Checker
Greg Reichert, GLR Software
This routine uses Google's spelling correction feature of their search engine to perform spell checking. When a mis-spelled word is submitted, Google attempts to correct the spelling and persents it as a phrase near the top of their result page. The corrected phrase is always after the term "Did y...
Created on
20 years ago
Downloads
671
File type
AppStart - Auto-Update Application Starter
Greg Reichert, GLR Software
The purpose of this application is insure that the local copy of the application, and it dependent files, are always up to date. The remote copies of the application can be located either on LAN/WAN server, HTTP web server, a FTP site, or even a Email attachment. In addition, the AppStart can instal...
Created on
20 years ago
Downloads
2423
File type
Simplest Treeview for VFP
Greg Reichert, GLR Software
This control is a simple treeview using the WebBrowser control and a HTML file to drive a VFP form. The tree itself is a standard html outline using the "UL"/"LI" tags. What make this the simplest, is that the only one OnClick event is established, and that is at the first (or root) "UL" tag.
Created on
20 years ago
Downloads
3005
File type
Rating
5.00/5.00
Changing Colors and Styles of controls at run-time
Greg Reichert, GLR Software
This object, when dropped on a form, automatically sets the colors and other properties of all the controls on the form to those that match the same properties on the Style object. Set the properties value once on the Style control, and when the form is ran, then all the controls with the same prop...
Created on
20 years ago
Downloads
1571
File type
Freeware
Automated Language Translator - ver. 1.50
Greg Reichert, GLR Software
The Locale class automatically translates captions, tooltips, and statusbar text from one language to an alternate language with the use of the internet, then stores the translation for future use and faster translations. Now with 8 languages and uses 11 web-sites for the best and fastest possible t...
Created on
20 years ago
Downloads
2236
File type
Remotely exit VFP applications across the network
Greg Reichert, GLR Software
Monitor and remotely terminate running application from across the network. Great for those times you need to force users out of applications they have left running. Also, the administrator can check for dead applications or those that are reporting they are in a critical section of the program, lik...
Created on
20 years ago
Downloads
4146
File type
Freeware
Remember form position and size. v. 1.52
Greg Reichert, GLR Software
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 ...
Created on
20 years ago
Downloads
2088
File type
Freeware
A Mover control in the space of a single listbox
Greg Reichert, GLR Software
Link update only. Have you ever needed a Mover control, but space is limited. This control provides many of the same features as the Mover control, but all in the same space of a single listbox. There are several different demos of this in the download. Also, a couple of the demos use a slider con...
Created on
21 years ago
Downloads
1973
File type
Rating
5.00/5.00
Auto Hide a Form
Greg Reichert, GLR Software
Link adjustment only. Auto hide any form behind the VFP desktop, pop it back out when the mouse is hovering over it. The AutoHide class can be dropped on any form to provide the ability for the form auto hide itself behind the VFP border. This is similar to other autohide feature found in windows d...
Created on
21 years ago
Downloads
2244
File type