Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DbSchemaxf_DbSchemaDatabase Schema Information
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
DefaultExpression as String
The SQL column default as a string
ColumnName as String
The column name
SQLColumnFormat as xf_SQLColumnFormatEnum
The column xf_SQLColumnFormatEnum (the underlying functional type)
Call Template:
Dim s As String
s = xf.DefaultSchema.TranslateSqlDefaultExpressionToJet(DefaultExpression, ColumnName, SQLColumnFormat)
See Also:
Example 1:
Debug.Print objSchema.TranslateSqlDefaultExpressionToJet("GETDATE()", "InvoiceDate", xf_SQLColumnFormat_DateTime)
--> Now()