Side Tab level help goes here. Help should be informational and not instructional. So, inform the user what this page is for. The interface should be intuitive enough to figure out what can be clicked. Ut tortor mauris, aliquam nec, placerat sit amet, pulvinar in, wisi. Nunc ullamcorper adipiscing nunc. Nulla sagittis. Curabitur convallis porttitor felis.
AddCancel- This will add a datasource to the dropdown box.
Data Source Name (DSN):
Username:
Password:
- Data Source Name (DSN):
- Username:
- Password:
Table:
The foundation of every database is a table. Every database consists of one or more tables, which store the database’s data/information. Each table has its own unique name and consists of columns and rows.
Fields:
Ordering:
Primary Key: Primary Key visible?
A primary key is used to uniquely identify the rows in a table. Each primary key value must be unique within the table. Furthermore, the primary key field cannot be null because the database engine requires a value to locate the record.
- Type
Initial Sort Order:
Ascending
Descending
SQL "Where" Clause:
Use ''0=0'' (without the quotes) to return all records. Do not specify ''WHERE '', but do specify everything that comes after it.
No records found message:
When the database is queried, and no records are returned, this is the message that will be display. It gives the user feedback that their request has been processed.
Bit Field Masking: True: Displays "Yes/No". False displays icons, or "1 or 0" values.
Date Masking:
Data masking restricts input/output of data to a specific series of characters called a "mask". Leave blank for raw output.