Downloads
Search: 

PocketFox
Saturday, November 10th, 2012 at 15h04
If you are at one of your clients, that runs VFP apps developed by you, and you need to create a small program to be used only that time, or need to open a VFP table and perform some mantainance tasks (browse, pack, zap, rebuild indices, create new indices, modify table structure, add, delete or modify records, export table selected rows to files of many different formats, etc). It also allows the average VFP Client-Server developer to connect to existing datasources (SQL Server, Sybase ADS,...
General information
URL:http://www.pocketfox.org/
Downloads:2024
File type:Freeware
Rating:5.00/5.00 (1 rate) Rate this entry
Description
If you are at one of your clients, that runs VFP apps developed by you, and you need to create a small program to be used only that time, or need to open a VFP table and perform some mantainance tasks (browse, pack, zap, rebuild indices, create new indices, modify table structure, add, delete or modify records, export table selected rows to files in many different formats, etc) and your client does not have a VFP developer version, neither its runtimes, you can take it with you and install along PocketFox.

PocketFox is a simple program written entirely in VFP 9, that also allows the average VFP Client-Server developer to connect to existing datasources (SQL Server, Sybase ADS, MySQL, PostgreSQL, Oracle, FireBird, SQLite, InterBase, MariaDB, Informix, MS Access and Visual FoxPro) and perform various tasks like listing available tables, show table fields attributes, indexes, check tables's number of rows, browse it, execute all SQL commands supported by the backend (in a SQL command window), browse SQL Select result sets, copy its contents to a number of different file types, save/load SQL commands etc.

This enables you, among many other things, to previously test SQL statements that latter you will use in your app, extract data from database tables and so on, because it will accept the SQL commands of the SQL engine you are connected to.

PocketFox also supports many simultaneous open connections with mixed SQL engines (the limit will be determined by your needs and your computer capacities), that makes easy for you to shift from one connection to another within the same program, without the need to have the knowledge of many database administration tools, that (some/many times) are out of your reach due to security reasons (or other), determined by the database administrator of your client.

PocketFox is not intended to be used only by Visual FoxPro developers, it can be used by any IT professional looking for a simple tool to access databases and perform SQL operations.

If you don't want to have the Visual FoxPro menuns to be displayed, simply start PocketFox passing the parameter ODBConly (it is not case sensitive) or select the "Show/Hide Visual FoxPro Menus" option in the "PocketFox" menu.

PocketFox was developed to help in those situations descibed above, and many others, as a basic aid, to be used when you don't have any other tool to perform those tasks, that PocketFox attempts to address. Note that it was not my intention do develop a "real" professional/commercial VFP utility. Certainly more experienced programmers have their own set of more sofisticated tools, but those who haven't, will find PocketFox quite usefull.

PocketFox can be left installed at your client, if you do remote maintenance of your apps, or even be used by power users at your client to help you, if you think that's a good idea.

The idea (and the name) of PocketFox came up from the Swiss Army Pocket Knife, that has many tools, none of them are intended for professional use, but it can save you in many inesperate situations. PocketFox is a very small program and can easily be carried in a pen drive or in your cell phone memory.

PocketFox was extensivelly tested and has error processing code all over the app. If an unrecoverable error occurs, it will produce a trace/dump file that can be sent to me, so I can find and fix the problem. But unexpected errors occurs, that makes part of a programmer's life, and with PocketFox it won't be different.

PocketFox doesn't need, or mantain, any additional files for its operation. All you need ro run it is its executable and the VFP 9 SP2 Runtime. And PocketFox is free.
Created by
Fernando Alvares, Independent

Comments
NoCreated byCreated onComment
1.Kenneth Tamayo12/11/2012 18:04Thank you for sharing this wonderful VFP utility with the community. It comes in handy in the scenarios described. I am familiar with the early version ('vfpscript') and used it in the past... this one is much improved.
2.Fernando Alvares13/11/2012 06:58Thanks Kenneth! But keep looking for new versions, I'm fixing errors as I detect them, or our fellows tell me about.
3.Tanvee Ul Hassa Shaheen27/11/2012 21:30Dear Sir, Very good utility..and thanks for sharing. I point out some missing (although you are updating) In ODBC Connection menu Please add Mysql also and think about modification in Form (Modify form,do Fomrs) thanks again for free sharing your value able efforts.
4.Fernando Alvares28/11/2012 07:40Tanvee, MySQL is on the way (hope soon will be availabe). Unfortunatelly operations involving Forms (Create Form, Modify Form and Do Form) are not allowed at runtime. Thanks for your comment!
5.Fernando Alvares28/11/2012 15:06Version 5.3.3277 of PocketFox (just released) now supports MySQL, As this is the first release supporting MySQL, you may expect some issues.
6.Fernando Alvares17/12/2012 07:47PocketFox/ExecScript source code is available here.
7.Fernando Alvares29/12/2012 19:03You can find PocketFox/ExecScript Scripting Language syntax and some usage examples, here.
8.Fernando Alvares21/01/2013 06:31PocketFox 6.2.5332 (BETA) ready for download. Many new functionalities were added, like FTP commands and a new scripting language (PSL).
9.Bill Amidon30/01/2013 10:57Thank you ! Great job
10.Dmitry Chunikhin17/11/2013 15:53Awesome tool.

Add a comment

More downloads created from this member
Wednesday, December 26th, 2012 at 10h24
The idea of FireFly came out when I was chatting with a friend who works for private companies, as a consultant in the strategic planning area. He told me about which tools he frequently uses to develop his work. Some of these tools are very sofisticated Excel spreadsheets, containing lots of VBA (Visual Basic for Applications) code.
Sunday, August 21st, 2005 at 14h34
If you are at one of your clients, that runs VFP apps developed by you, and you need to create a small program to be used only that time, or need to open a VFP table (not a VFP database - DBC) and perform some mantainance task (browse, pack, zap, rebuild indices, create new indices, modify table structure, add, delete or modify records, export table selected rows to many different formats, etc) and your client does not have a VFP developer software version (only its runtimes), maybe VFPscript ca...
Monday, November 3rd, 2003 at 20h45
SQLdict is a simple program entirely writen in VFP (current version was built with VFP 9) that allows the novice VFP Client-Server developer to connect to existing datasources (SQL Server, Oracle, Informix, VFP etc) and perform various tasks like listing available tables, show table field attributes, indices, check tables' number of rows, browse its rows, execute all SQL commands supported by the backend (in a SQL command window), browse SQL Select result sets, copy its content to a number of di...