Home > Data Manager > Table From Form

Table From Form

Form Master 2008 can create an External Table from the Fields defined in the Form.

• Connection String: The Connection string to the Data Resource. Leave blank to use the Default System Connection String. If defining a Connection string, it must be set before any Mappings are started since Mappings are based on what Tables exist in the Database
• New Table Name: The name for the new Table which will be created in the Database

The Grid Columns:

• Form Field: This will be the name of the column in the SQL Table. This value is taken from the "Field Name" value in the Common Options section.
• Type: The Data Type for the SQL Table Field Create an Appendix  
• Length: The Length of the SQL Field. For Text fields, Char, NChar, VarChar, NVarChar the value can be set to the greatest expected value for the field. In cases where the ammount of data is unknown the Text or NText Data Types should be used as will allow more data then can be sent in a browser.
• Prec. & Scale: Precision is the number of digits in a number. Scale: Scale is the number of digits to the right of the decimal point in a number. Precision and Scale only apply to Numeric and Decimal Data Types and will be ignored otherwise
• Nullable: If Checked the SQL Table will allow Null as a Value in the Column
• Ignore: If Checked the Column will not be created in the SQL Table and no Mapping will be created for it. This is usful for Hidden Fields or Conformation type Fields which do not need to be stored.

The Process:

1. Select the "Create Table From Form" Radio Button
2. Enter a Name for the New Table (a name with no spaces or special charaters is recommended)
3. Choose the appropriate Data Type and Length for the Form Field
4. Check the Nullable Checkbox if it there is no Required Field Validator on the Field
5. Check if the Field should be Ignored
6. Click the "Commit Operation" Button

See also