Public Property Get CanCoerceNullToEmptyString() As Boolean
Is the column a string type, non nullable but empty string allowed
Core properties and methods
Is the column a string type, non nullable but empty string allowed
Column description
The column length is this number of characters (if string type)
Column name
Column name contained in square brackets
Column name contained in square brackets with a trailing '='
The column order in the table
The column number of decimal places (if applicable)
The column default value or expression
Don't test for a FK dependency in these tables when deleting a record
- a cascade delete is at work
Is a Null or an empty string value disallowed in the column ?
Is an empty string value disallowed in the column ?
The FK column reference (in the FK table) for the column, if any
The FK table reference for the column, if any
Format the column value based on this column's schema, but just do type checking , not null and length checking etc.
Assumes that strings are not quoted prior to passing in.
Formats the passed variant for inclusion in an SQL UPDATE/INSERT command, eg. Date, null, numeric etc.
Assumes that strings are not quoted prior to passing in.
Strings are quoted as part of the formatting operation, unless CheckForQuotedStrings=true and they are already quoted.
Does the column have a default value specified ?
Is the column computed (MSSQL) ?
Is the column an autonumber/identity ?
Is the column nullable ?
Is this column part fo the primary key ?
Is the column a string type
Is the column a pointer to a global text storage table
The column native (MSSQL or MS Access) type
The table schema to which this column belongs
Initialises the column schema with values
Internal functional column type
Test for the column being unique over a specific domain
Trim the column to this number of characters (if string type)
If the user tries to enter a new value that matches an existing hidden value, trigger the hidden value to be shown