Folder Scanner - written in REALbasic 2007 r2 for Windows XP sp2

After trialing a number of automated drive indexing utilities (Like Google Desk Top and Windows XP Indexing)
that seemed to use far too many of my CPU resources and seemed to slow my computer down. 
I was spending more time making sure they were NOT running than actually using them.

I also wanted to have a fair go at discovering:

How far I can could get with REALbasic 2007 r2
How intuitive is the interface.
How we use existing databases and com objects.
How stable is the REALbasic IDE. 
How close the REALbasic language is to VB6. 
How the help files interacted.  Including the Quick Start, Users Guide, and Users Manual.
How regular are the product releases.
How much does REALbasic cost.
How good is the support from REAL Software and the Community Forums.

This is my first application in REALbasic. 
I started from scratch 5 days ago.  i.e. Knowing nothing about REALbasic.
I've been working on this app and researching REALbasic part time.
Specifically,  NOT 8 hours a day.

Yes, things will be missing and I'm sure everything can be executed in a more efficient manner. 
All will come as a matter of time and experience with REALbasic.

I just wanted to prove how much I could accomplish in a relatively short amount of time.

Overall

Overall, I'm very pleased with the outcome. 
REALbasic was easier for me to learn and constructively use, I believe, coming from a VB6 background.
Some features of REALbasic are better than those in VB6.
Specifically, the search and replace utility. 
      Although NOT intuitive, certainly a better design.
And threading, which was so easy to do, I was sure I missed something. 
And when click on the property of a control the value is automatically highlighted. 
     One click instead of three in VB6.  Excellent.
A standard separator line control.

I've created a working application that could be useful to any who care to investigate and use. 
And have been able to contribute in some part to the REALbasic community.

I offer the source in good faith as a starting point only.
Feel free to use my code and layout as you see fit.
Feel free to change the app and please be sure to share enhancements and code with the rest of us in the REALbasic world.
Finally, be sure to give credit where credit is due and DON'T claim this exact application as your own.



Contains example of:
     This is a coding sample for the following:

 Controls:
     Window, TabPanel, ListBox, StaticText, PushButton, EditField, and Thread.
     Includes form resizing.
 
 Coding:
       Subroutines, Functions, Database Connectins and SQL Queries, Classes, Properties, Methods, and Modules.
     FolderItem, Item and TrueItem,  SelectFolderDialog, Threading, Shelling, Error Trapping, Do Loops, Constants, and Enums.

   
Folder Scanners Initial Graphical User Interface

A screen shot of the initial Folder Scanner Graphical User Interface where you can:

Choose Folder and Start - Opens a Select Folder dialog where you can select a single folder. 
Once the folder is selected Folder Scanner will begin scanning the folder and sub folders for files
and write each File Path and File Name to its database.

You'll be able to watch its progression as the the Folder and File Names and File Count is displayed.

Use the clear button to clear the list box.
You'll also be able to stretch the form at any time.

    Folder Scanners Search Database Tab.

A snapshot of Folder Scanners Search Database tab where you will be able to:

You can enter search criteria for the Folder Path and the File Name.
Use the * buttons to clear the text box contents.
Use the Search DB button to begin searching the database.

Use the SQL text box to copy the ODBC Database SQL query into the clipboard.
View the results of the query in the list box.
Use the Clear button to clear the list box.

Use the Open Containing Folder to open the files folder in Windows Explorer and highlight the file for action.
 

Folder Scanners FolderScanner.zip download file contents.

Please be sure to run ANY download from ANYWHERE thru your virus protection software. 
Some virus protection software is automated, some are not.

Place nice constructive comments here

These are some nice comments about what I've learned over the last five days of REALbasic 2007 r2 research.

 

Some ideas regarding future enhancements

These are some nice comments about what I could add to the Folder Scanner Project.