Differences

This shows you the differences between two versions of the page.

--- v5:dictionary:column_attributes [2016/04/03 01:34] – [ENUM] mnewnham
+++ v5:dictionary:column_attributes [2024/08/31 16:26] (current) – multiple column definitions separated by comma dregad
@@ Line 1: / Line 1: @@
 ======= Dictionary Column Attributes =======
 ====== Description ======
-When creating a column in a table using the dictionary methods, the information provided must confirm to the following specification. Each column created has a number of mandatory and optional parameters.
+When creating a column in a table using the dictionary methods, the information provided must conform to the following specification. Each column created has a number of mandatory and optional parameters.
 ====== Basic Syntax ======
 The basic syntax of the attributes is as follows:
-  * All the information for the column must occur on a single line.
+  * All the information for a given column must occur on a single line.
+  * Multiple columns definitions must be separated by a comma '',''
   * The line ending may be a newline or carriage return/newline combination.
   * Each attribute must be separated by at least one tab or space.
@@ Line 38: / Line 40: @@
 =======  Attributes =====
 ===== Column Name =====
-  * The column name must conform to any database specific standards related to naming and length.
+  * The column name must conform to any database specific standards related to naming and length. If the name contains spaces, then it should be surrounded by backticks '' `col with spaces` ''. Note that this is an internal designator, and does not represent the character used by the database in SQL statements.
 ===== Meta Attributes =====
   * The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5:dictionary:metatype|metaType]] descriptions, not the database definition for the type.