Home Cart [Log In] About Us Contact Us

Object Reference

xf_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()
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd