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

PocketFox
Fernando Alvares, Independent
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, MySQL, PostgreSQL, Oracle, FireBird, SQLite, InterBase, MariaDB, Informix, MS Access and Visual FoxPro) and perform various tasks over the tables.
Created on
8 years ago
Downloads
2238
File type
Freeware
Rating
5.00/5.00
General information
Rating:
5.00/5.00 (1 rate) Rate this item
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
Thank 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. Kenneth Tamayo, November 12, 2012

Thanks Kenneth! But keep looking for new versions, I'm fixing errors as I detect them, or our fellows tell me about. Fernando Alvares, November 13, 2012

Dear 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. Tanvee Ul Hassa Shaheen, November 27, 2012

Tanvee, 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! Fernando Alvares, November 28, 2012

Version 5.3.3277 of PocketFox (just released) now supports MySQL, As this is the first release supporting MySQL, you may expect some issues. Fernando Alvares, November 28, 2012

PocketFox/ExecScript source code is available here. Fernando Alvares, December 17, 2012

You can find PocketFox/ExecScript Scripting Language syntax and some usage examples, here. Fernando Alvares, December 29, 2012

PocketFox 6.2.5332 (BETA) ready for download. Many new functionalities were added, like FTP commands and a new scripting language (PSL). Fernando Alvares, January 21, 2013

Thank you ! Great job Bill Amidon, January 30, 2013

Awesome tool. Dmitry Chunikhin, November 17, 2013

Add a comment
More downloads created from this member
Fernando Alvares, Independent
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 (V...
Created on
8 years ago
Downloads
962
File type
Freeware
Fernando Alvares, Independent
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 str...
Created on
15 years ago
Downloads
1809
File type
Freeware
Rating
5.00/5.00
Fernando Alvares, Independent
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...
Created on
17 years ago
Downloads
2801
File type
Freeware
Rating
4.00/5.00