The LA Fox Developer Newsletter

June 2000

ADO Jumpstart (Con’t from page 8)

This causes the recordset produced by the second SQL statement to become available. Thus, the next set of commands loops through the records from the Orders table. This technique is ideal in those situations where you may need to populate Combo or ListBox controls.

The previous example references a collection that has not been discussed yet, the Parameters collection. The Parameters collection and the individual Parameter objects that it contains serve several purposes. One purpose is to provide the capacity to create parameterized queries. Another purpose is to provide the ability to send arguments to, and return data from, a stored procedure. For more information on the Parameters collection, see the Command Object section of this paper.

To be continued.

Useful Info/Utilities (Con't from page 6)

“Dependency Walker is a free Microsoft utility that scans any 32-bit or 64-bit Windows module (exe, dll, ocx, sys, etc.) and builds a hierarchical tree diagram of all dependent modules. For each module found, it lists all the functions that are exported by that module, and which of those functions are actually being called by other modules. Another view displays the minimum set of required files, along with detailed information about each file including a full path to the file, base address, version numbers, machine type, debug information, and more.”

[It’s a 420k download. YOU NEED THIS PROGRAM!! DC]

Toomps for Folders

I remember that a few months ago we were discussing the problems of keeping track of what’s in all those directories on the hard drive, and I said ‘What I’d like to see is ToolTips on the Folders.” If the folder name is IBX3I, you could hold the mouse over it and see that it was “Ibex Corp’s software for 31-bit mouse reversers” or something like that. Well guess what, you can do it!

The following technique works in Windows 98 and Windows 2000; it doesn’t work on NT 4.0 or Win 95.

The first thing you have to do is create a “desktop.ini” file, in the directory itself. Using any text editor (NOT a Word processor), enter the following:

[.ShellClasslnfo]

ConfirmFlleOp=O

lnfoTip=This is the tooltip I want displayed

The other thing you have to do is make the directory itself a

System file, so the desktopini will be examined. You can use

Explorer (“properties”) to see whether it’s a system file, but you

can’t set it from there. Open a command window (Start I

Programs I DOS), and enter the command:

(Con’t, adjacent column)

Useful Info/Utilities (Con? from prey, column)

attrib +s "C:\program files\IBX32 (or whatever)

** You have to use quotes if there is a space in the pathname.

Exit back to Windows, Explore, and hover your mouse over the folder. Voila! (It works in either the regular or Explore view, but not in the Explore’s treeview frame.)

Side effects: The ConflrmFileOp=0 entry allows you to delete the folder without worrying about the System attribute.

Another setting you can add to Desktopini:

tconFile=ThisFolder.ico

lcontndexO

This will use your ThisFolder icon instead of the Windows default.

If you “customize” the folder with the Customizing wizard, it will build a desktop.ini. You can just add your InfoTip to it.

Join

LA Fox

...and visit our website at:

h ttp ://www. Ia fox. org

It Can’t Get Any Easier.......

We’ve come up with an easy way to submit articles to the LA Fox DeveloperNewsletter one that has been overlooked for a long time.

You can submit your articles to Barry Lee at CIS# 72723,3422 on Compuserve, orbrlee@earthlink.net.

These articles can be on any FoxPro-related topic, whether it concerns a new technique you’ve discovered, a certain development technique you may favor over others, book reviews, etc. Editor reserves the right to edit or offer constructive comments concerning submitted articles and accepted articles shall be considered to be in the public domain.

The quality of this newsletter really depends on the members that support it, not just read it. And I think we’d all be surprised by the useful information that could be circulated around the membership.

Page 9