xf_DbConnectDatabase Access Wrapper

Public Function DumbSqlFormat (
ValToFormat As Variant
) As String

Format a variant for SQL based only on its type

ValToFormat as Variant

The variant value to format

Call Template:

Dim s As String

s = xf.DbConnect.DumbSqlFormat(ValToFormat)

Example 1:

Debug.Print xf.DbConnect.DumbSqlFormat(#1 January 1850#)   -> #1 Jan 1850#
Debug.Print xf.DbConnect.DumbSqlFormat("Test")             -> 'Test'
Debug.Print xf.DbConnect.IsValidSqlSmallDate(Null)         -> NULL
Debug.Print xf.DbConnect.IsValidSqlSmallDate(23.4)         -> 23.5

Object Reference

xf_DbConnectDatabase Access Wrapper

Public Function DumbSqlFormat (
ValToFormat As Variant
) As String

ValToFormat as Variant

Call Template:

See Also:

Example 1:

Object Reference

Public Function DumbSqlFormat (ValToFormat As Variant) As String

ValToFormat as Variant

Call Template:

See Also:

Example 1:

Public Function DumbSqlFormat (
ValToFormat As Variant
) As String