Logo
Home Cart [Log In] About Us Contact Us

Object Reference

General > xf_General > QuoteWithEscape (Quoting and Escaping Functions)

xf_GeneralGeneral Functions

Public Function QuoteWithEscape (
i As Variant,
QuoteChar As String
) As String

Quotes the passed value like q(), but using the passed in quote string

i as Variant

The variant value to quote

QuoteChar as String

The string to use for quoting and escaping

Call Template:

Dim s As String
s = xf.Gen.QuoteWithEscape(i, QuoteChar)

See Also:

dq
q
QuoteByQuoteType
QuoteWithEscape
Unquote

Example 1:

Docmd.RunSQL "UPDATE tblSample SET SampleCount=1 WHERE SampleDate=" & QuoteWithEscape("1 Sep 2015", "#")
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd