Hi,
In the last few months I've been learning how to use SPT to deal with remote tables (Oracle, MS SQL Server and Informix), because I got involved in a project to implant an ERP package by JD Edwards (called OneWorld), and to connect many VFP apps to it. For all that I used, and still am using, SPT.
To learn the basics of SPT I counted with precious help from many fellows (Vlad, George, Larry, Mark, Sergey, Armin, Cetin, just to name a few) that are real experts in this matter. Thanks to you all!
I started writing small prgs with specific code to make tests, and after a while I realized that it could be done thru a simple utility that, having some basic functionality, would give me most of what I needed. Then started to assemble, piece by piece, this small utility, named SQLdict.
The basic idea behind all that is: many developers (and that's my case) don't have access to the developing environment of Oracle, Informix etc, and many DBAs are unlikely to give you access to it, for many reasons.
Then how can you get the names of all tables of a given database, it's row attributes, browse its contents, get their indexes, perform test SQL Selects and see the results or save them to files etc? One answer is: MS could bundle a SQL Explorer (like Delphi has) in the VFP package. But it doesn't. At least until now. So I solved my problem with SQLdict. It's no "rocket science" VFP app, but it does the job fairly.
I've put SQLdict.exe available for download in Black-Beans web site downloads page (
http://www.black-beans.com.br/downloads/sqldict.zip), packed in a zip file (40 kb). All you need is to download it, unzip it to any directory of your choice and run it.
Those of you that think it would be worth to check it, are very welcome. SQLdict has its user interface written all in english, albeit it has no help file it is very straightforward to use (well, that's what I think!) and has tooltips in all command buttons.
Your comments and suggestions will be very appreciated.
Thanks!
Fernando
PS. I can't assure you SQLdict is bug free, but what app is and, of course, I just start learning SPT :)
