|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.