Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_ScripterSQL Script Generation and Processing

Public Function RelationFieldList (
R As DAO.Relation,
Optional UseForeignName As Boolean = False
) As String

Return the relation's field/column names as a comma separated list.
In MS Access, any foreign key constraint is associated with a DAO Relation object.

r

The DAO.Relation

R as DAO.Relation

(no description)

Optional UseForeignName as Boolean = False

Take the name from the Relation ForeignName property instead of the Name property

Call Template:

Dim s As String
s = xf.Scripter.RelationFieldList(r, R)
s = xf.Scripter.RelationFieldList(r, R, UseForeignName)

See Also:

Example 1:

colList = RelationFieldList(rel)
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd