Fox & SQL command line utility - Pocket Fox

The place to discuss and announce issues that don't relate directly to ProMatrix, but that are of interest to ProMatrix users. Feel free to use the Chatter forum as you like (as long as your use is in good taste).

Fox & SQL command line utility - Pocket Fox

Postby billamidon » Thu Jan 31, 2013 5:47 am

I ran across this and find it useful. It provides a dot prompt w/o an install of VFP.

http://www.pocketfox.org/

PocketFox is a simple to use program, that allows the client-server developer to connect, simultaneously, to many diferent datasources (SQL Server, Sybase ADS, MySQL, PostgreSQL, Oracle, FireBird, SQLite, InterBase, MariaDB, Informix, MS Access and Visual FoxPro) and perform various tasks, such as list available tables in the databases it is connected to, 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, create and run scripts written PSL and more.

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. If you want to know more about PocketFox just click here.

Also check PocketFox Change Log to see what changed in each version.
billamidon
 
Posts: 122
Joined: Sun Jul 18, 2010 5:32 pm
Location: Mondovi, Wisconsin USA

Return to Chatter

Who is online

Users browsing this forum: No registered users and 1 guest

cron