Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fichiers
Ajouter
Recherche: 
Recherche

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.
Créé le
Il y a 11 années
Téléchargements
2511
Type de fichier
Freeware
Résultat de votes
5.00/5.00
General information
URL:
http://www.pocketfox.org/
Résultat de votes:
5.00/5.00 (1 rate) Évaluer cet 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.
Créé par
Fernando Alvares, Independent

Commentaires
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

Ajouter un commentaire
More downloads created from this member
FireFly
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...
Créé le
Il y a 11 années
Téléchargements
1120
Type de fichier
Freeware
VFPScript
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...
Créé le
Il y a 18 années
Téléchargements
1885
Type de fichier
Freeware
Résultat de votes
5.00/5.00
SQLdict
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...
Créé le
Il y a 20 années
Téléchargements
2880
Type de fichier
Freeware
Résultat de votes
4.00/5.00