Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_ControlsControl Related

Public Function ReadBoundControlsFromDb (
f As Form,
dbConn As xf_DbConnect,
sqlStr As String ,
Optional BindingGroupNum As Integer = 0,
Optional UseExtendedRSType As Boolean = False ,
Optional SuppressError As Boolean = False
) As Boolean

Read data from single-record SQL result set to controls identified by tags of form "Bx:FieldName" where x is the group number Optionally "Rx:FieldName" reads the data but does not write it later (good for comparison copies of data for 'dirty' checks) Error occurs in ODBCDirect workspace connection dbOpenForwardOnly recordset where a memo column is returned In this case, call with UseExtendedRSType=true

DbConn

The DbConnect object to use to read the data

f as Form

The target form.

dbConn as xf_DbConnect

(no description)

sqlStr as String

The SELECT statement defining the data to be read

Optional BindingGroupNum as Integer = 0

The binding group. Multiple binding groups may be used to read several different datasets to the same form

Optional UseExtendedRSType as Boolean = False

Deal with ODBCDirect workspace connection dbOpenForwardOnly recordset where a memo column is returned

Optional SuppressError as Boolean = False

Don't display a message if an error occurs

Call Template:

Dim b As Boolean
b = xf.Controls.ReadBoundControlsFromDb(DbConn, f, dbConn, sqlStr)
b = xf.Controls.ReadBoundControlsFromDb(DbConn, f, dbConn, sqlStr, BindingGroupNum, UseExtendedRSType, SuppressError)

See Also:

Example 1:

xf.Controls.ReadBoundControlsFromDb dbs, me, "SELECT * FROM Category", 3
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd