Home Cart [Log In] About Us Contact Us

Object Reference

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)

See Also:

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