• Grid and Form Control

  • -

  • Jeff Knooren

Summary       Grid Control       Reports  
Summary       Properties       Fields  
  • Properties

  • -

  • Demo_Base

  • These forms will allow you to modify the properties for this object.
  • Datasource

  • -

  • Demo_Base

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

  • Data Source Name (DSN)

  • A DSN is a database where information is stored.
  • Add - This will add a datasource to the dropdown box.

    • 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.
  • - Date:

  • - Time: