Type Conversion

Public Function GetSqlColumnFormatFromMSAccessType(MSAccessType As DataTypeEnum) As xf_SQLColumnFormatEnum

Get the xf_SQLColumnFormatEnum given the MS Access DataTypeEnum. The xf_SQLColumnFormatEnum is an internal functional type specifying broadly how the type is to be handled rather than its internal details.


Public Function GetSqlColumnFormatFromMSSQLType(MSSQLTypeStr As String) As xf_SQLColumnFormatEnum

Get the xf_SQLColumnFormatEnum given the MSSQL type name. The xf_SQLColumnFormatEnum is an internal functional type specifying broadly how the type is to be handled rather than its internal details.


Public Function GetUnicodeLengthDivisorFromMSSQLXType(MSSQLXType As Integer) As Integer

Get the MSSQL divisor for the length specification passed in the SQL schema. 2 for unicode var types, 1 for ANSI types

Public Function SqlColumnFormatString(SQLColumnFormat As xf_SQLColumnFormatEnum) As String

Get the string description of the xf_SQLColumnFormatEnum.


Public Function TranslateSqlDefaultExpressionToJet(DefaultExpression As String, ColumnName As String, SQLColumnFormat As xf_SQLColumnFormatEnum) As String

Translate common SQL column default expressions to the MS Access equivalent