Hi Mike,

Two very cool scripts introduced with VFP 8 are zloc and zdef to show declared local variables and DEFINES. Another very cool use is the SET ORDER TO which will display all tags of the selected table.

I made a script that allows me to open any tables in our environment in just a few keystrokes.

Our environment is made with mainly four drives D: (duh!), H:, I: and S:. My desktop, prod env., testing env., pre-prod, etc. All the folders structure are the same there and it can get quite long. For exemle :

USE H:\Systemes\Donnees\SysAdmin\Reshumspeorg.dbf IN 0 SHARED ORDER CLE

This is over 70 keystrokes

The script I came up with allows me to type myuseX (where X is the drive I want to open the table on, if I issue myuse it'll use the current drive) and a list opens displaying all the tables, on the specified drive, that are part of our environment (the list is based on our admin table use to drives the opening and closing of tables in our apps so I'm sure it's always up-to-date and very fast as there is not disc access). There are 2 columns in the list, first is the physical name of the table so that I can type the few first letters to select the table I want and the 2nd if the FULLPATH of it.

So, to issue the same USE mentionned earlier, I just type

MYUSEH RESHU IN 0 SHARED ORDER CLE

and it will expend to

USE H:\Systemes\donnees\SysAdmin\Reshumspeorg.dbf IN 0 SHARED ORDER CLE

This is about 35 keystrokes, 50% less.

If I have to open 5 or 6 tables to open in a row, I just saved about 150 keystrokes in a few seconds. I can't live without it anymore! And in addition I saves a lot of mistakes etc.

You'll surely get to appreciate IS if you dig it!!
Sylvain

>Peter:
>
>Thank you for your reply.
>
>You are adding an angle to this that is new to me.
>
>I have poked inside the configuration for Intellisense and can see that there are places to do what you are referring to but I didn't understand the potential.
>
>Thank you for opening this door for me.
>
>Mike Smith