Node Query

Top  Previous  Next

This query is created for users that locate their crashes by a specific node to identify each location.

 

The following parameters are used in the where clause:

 

FirstDate: This is the first date parameter of the Date range field in the Node Study Settings tab.

 

LastDate: This is the last date parameter of the Date range field in the Node Study Settings tab.

 

Node: This is the Node field of the Node Study Settings tab.

 

 

Example where clause:

((Crash.CRASH_DATE BETWEEN :FirstDate AND :LastDate))

AND(Crash.REF_PT_ID = :Node_NUM))

In this example Crash.CRASH_DATE and Crash.REF_PT are fields in the client's collision database. The fields :FirstDate, :LastDate, and :Node_NUM will be entered when the user selects these values in the Node study.