Please enable JavaScript to view this site.

Queries extract the data required by Crash Magic from a collision database. All queries use the following fields:

AdminStudyQuery

 

AdminQueryEditor

Name: This is the name of the study query

 

Description: This is a description of the study query.

 

Connection: This is the connection that will be used by the query.

 

Query type: This defines how Crash Magic will view the query. The following query type options are available

lookupquery

dependentlookupquery

studyquery

 

Test: This button is used to test the current query. 0=1 is added to the where clause and the query is run against the connection.

 

Calculated fields: This check box selects the calculated fields that can be used with the query.

 

Create / Edit Query: This button opens the query editor.

 

Login as: This is the Crash Magic user that will be used to issue the query.

 

Login password: This is the password provided to the Crash Magic login screen.

 

 

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC