Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Generalxf_GeneralGeneral Functions
Public Function QuoteByQuoteType (
i As Variant,
QuoteType As xf_QuoteTypeEnum
) As String
Quotes the passed value like q(), but a passed enum is used to work out the quoting type. xf_QuoteTypeEnum: None, SingleQuote, DoubleQuote
i as Variant
The variant value to quote
QuoteType as xf_QuoteTypeEnum
None, SingleQuote, or DoubleQuote
Call Template:
Dim s As String
s = xf.Gen.QuoteByQuoteType(i, QuoteType)
See Also:
Example 1:
Docmd.RunSQL "UPDATE tblSample SET SampleCount=1 WHERE Gender=" & QuoteByQuoteType(nz(cboGender), SingleQuote)