(Very) Basic Database/Dialog ADO Sample from Stan Littlefield

Keywords:   ado odbc

---

The link below contains the current NAICS ( system for standardizing Industry Codes ) in XML format, a script, and a dialog.

The script ( which could be called traversing 101 ) simply opens the XML file as an ADO Recrodset, assigns variables to columns, then presents the data in a dialog with 'navigation' buttons. The code within the callback subroutine, is generic to any ADO Recordset.

The dialog/script could be modified to include Search and Filter Buttons, but at this point I really want to keep it simple.

The credit I afforded Marty in the script header is an understatement. He meticuloulsy pointed out the steps required to make my original dialog 'work' [or as Nancy asked at 4:30am this morning "What are you doing singing 'I Can See Clearly Now'?" ]

Hope this will be of some help to beginners who desire to move from ODBC to ADO.

For the rest of you, you might geta kick out of some of the Industry Code Descriptions.

stan

---

naics.zip