Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_DbConnectDatabase Access Wrapper

Public Function WriteBoundControlsToDb (
f As Form,
sqlStr As String,
Optional BindingGroupNum As Integer = 0,
Optional UseExtendedRSType 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

f as Form

The target form.

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

Call Template:

Dim b As Boolean
b = xf.DbConnect.WriteBoundControlsToDb(f, sqlStr)
b = xf.DbConnect.WriteBoundControlsToDb(f, sqlStr, BindingGroupNum, UseExtendedRSType)

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