The tutorial directory contains 2 additional files:

• macrocapper.btq - a BTEQ script that uses a macro to load temp tables for the autocapper procedure
• autocap_setup.mac - the macro that loads the temp tables

Start TeraForge; if it asks to load your previous project, click Cancel. At that point, a Logon dialog will be presented; click Cancel for that as well; we'll be generating a connection with our new project.

With an empty TeraForge, you can start creating your new project:

1. Use the File->New->Project menu to open the New Project dialog as before.
2. Fill in and close the Logon dialog as before. This should cause the Schema Browser to be filled in as before.
3. If you don't already have the tutorial directory open on your desktop, open a Windows Explorer and navigate to the tutorial directory.
4. Using your mouse and the Control key, select the following files in the tutorial directory window:
   1. macrocapper.btq
   2. autocap_setup.mac

   

5. Using drag-and-drop, drag the selected files over the New Project dialog and drop them.

   

6. Add the remote autocapper procedure component by
   1. open the tfgtutorial database node of the Schema Browser by left-clicking on its open/close indicator
   2. left-click on the AUTOCAPPER procedure to select it
   3. right-click and hold on the procedure, and drag it into the New Project dialog.

   

7. Click on the macrocapper.btq entry in the New Project dialog, and click Set Main to set it as the main component.
8. Click the OK button, and create a new project file named macrocapper.tfg in the Save As dialog.

You should now have 3 components in your Source Notebook:

Using the Project->Compile menu, compile the project. You will once again be asked to define the environment variables used by the BTEQ script:

Fill in the values as before and click OK to close the Define Variables dialog. Compilation should complete without errors this time.

If you take a look at the script and macro you've just loaded, you'll see that you've just moved the various INSERT...SELECT... statements out of the script and into a macro. The macro has 2 parameters: the track code for the track for which you're collecting handicapping information, and the racedate of the races you're handicapping. You'll also see that the script executes the macro using "named" parameters, which lets you specify the track code and racedate parameters in any order (in this case, in the reverse order).

To start our debug session, set a breakpoint at the beginning of the new macro at line 8.

Now click Continue . TeraForge should stop at your breakpoint. Open the Stack View and click the open/close indicator for the Macro frame. You should see the macro parameters with their input values:

Now single step through the macro using Step Over . Notice that the results of each statement are displayed in the Results Window:

Now click Continue and let the project run to completion as before. Once again, you can check on the results in either the export file, or in the Stack View prior to leaving the procedure.

Finally, exit TeraForge, but using the close icon in the upper right corner:

As before, you will be prompted to exit, to save the project changes, and to move components. In this case, leave the new macro as a local component, and simply click OK in the Move Component dialog. TeraForge will exit.