Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
- xf_Base
- xf_BaseInstance xf_BaseInstance
- xf_BaseMin
- xf_Globals
System Library

xf_BaseInstanceXF Base Module

Public Function q (
i As Variant
) As String

Adds single quotes around the passed value. Quotes are escaped, so for example if the value O'Leary was passed, the result would be 'O''Leary'. This form of escaping is supported by JET and MSSQL Server. The value NULL returns empty quotes (ie. ''). Using the q() function also protexcts from SQL injection attacks and results in more readable code.

i as Variant

The variant value to quote

Call Template:

Dim s As String

s = q(i)

Example 1:

1	`Docmd.RunSQL` `"UPDATE tblSample SET SampleCount=1 WHERE Gender="` `& q(nz(Me.cboGender))`

Object Reference

Public Function q (i As Variant) As String

i as Variant

Call Template:

See Also:

Example 1:

Public Function q (
i As Variant
) As String