Source Property

object.Source as String

Use

Data control, DataGrid control or Recordset object

For a Data control, DataGrid control or Recordset object, if the Server property for the corresponding Connection object is set to DBServerADO, the Source property specifies one of the following: a Command object variable, an SQL statement, a stored procedure, or a table name. If the Server property is set to DBServerDDM, the Source property specifies a file or member name.

ClosedExamples

The following two subprocedures filter the records displayed in an inserted datagrid based on the text entered by the user and display all records in the recordset respectively. A full working example can be found in demonstration.sid.

VBSCRIPT

Sub FilterCustomerRecords()

strKey = App.ActiveForm.txtCustomerKey.Text

if (Len (strKey) = 0) then

App.ActiveForm.grdAttachmentsList.Source = "SELECT * FROM DocumentList"

else

strSQLStatement = "SELECT * FROM DocumentList WHERE EntityRef='" & strKey & "'"

App.ActiveForm.grdAttachmentsList.Source = strSQLStatement

End if

App.ActiveForm.grdAttachmentsList.DataBind()

End Sub

 

Sub AllCustomerRecords()

App.ActiveForm.grdAttachmentsList.Source = "SELECT * FROM DocumentList"

App.ActiveForm.grdAttachmentsList.DataBind()

End Sub
Link Object

Each DDE link has a unique application name (Source) and topic.

The DDE topic broadly defines the type of data to be exchanged. For file-based applications, the topic is usually a filename. For other applications, the topic is an application-specific name.

The source (application) name and topic that define a link cannot be changed during the course of the conversation.

Applies To

Link object | Recordset object | DataGrid control | Data control

See Also

DataBind method | DataUnbind method | ConnectionString property | Server property | Topic property | Microsoft DDE reference guide

© 2004-2021 looksoftware. All rights reserved.