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 com-

mands 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 num-

bers, 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 proces-

sor), 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.

Reference:

Microsoft Knowledge Base, “Shell Basics”

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 develop-

ment 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.

So.

How ‘bout it?

Page 9