The following is displayed if you selected Local or Linked Server.
The following option are configured in this dialog box:
|
Field |
Description |
|---|---|
|
Server |
Enabled when the Local or Linked Server option is selected. This specifies either the local or linked server. |
|
Database |
This field should contain the name of the database to which WorkView will connect. Depending on the type of database, this field may be blank. |
|
Table Name |
This field should contain the name of the table from which you want to pull information. When using a SQL Server database, the table name must be prefaced with the corresponding schema name. For example if the table is in the dbo schema, this field would contain dbo.TableName. |
|
Truncate timestamp for date queries |
This check box should be selected when an external database uses the SQL_DATE datatype for columns. When selected, all WorkView DATE types within the class are assumed to match this database specific datatype. |