ODBC links to Crash / Location / Street / Node / Int

Several new functions have been added to the filter.  They are @LocAttr; @StreetAttr, @NodeAttr; @IntAttr; @CrashAttr.  These functions can be used to access data in ODBC data tables outside of Intersection Magic.  The data tables for these attributes are set up by Intersection Magic when creating the ODBC tables, but may be located in any appropriate ODBC share.

Editing of this data currently must be performed directly in the MS Access table directly.  There is no facility in Intersection Magic to perform this.

Locations are identified by their number in the Virtual Locations Manager.  The @LocAttr() function takes one parameter, the field name.  It returns the value of that field where the locationmatches the location of the crash record in question.

Streets are identified by their name.  The @StreetAttr() function takes two parameters, the street number (1 for primary, 2 for cross) and the field name.  It returns the value of the the field whose street name matches the street of the crash in question.

Nodes work exactly like Locations, above, but refer to the node number.

Intersections are identified by their primary and cross street names.  The @IntAttr() function takes one parameter, the field name.  It returns the value of the field where the intersection matches the street names of the crash in question.

Crashes are identified by their case id number.  The @CrashAttr takes one parameter, the field name.  It returns the value of that field where the case id number matches the crash in question.