Jaa

Pull Method (RDA)

  • Artikkeli

Downloads data from a remote Microsoft SQL Server database and stores that data in a single table in a local Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) database.

Before calling the Pull method, you must set the following RDA object properties:

  • The InternetURL property must contain the URL of the SQL Server Compact Edition Server Agent.
  • The LocalConnectionString property must contain the OLE DB connection string for the SQL Server Compact Edition database on the device.
  • The InternetLogin and InternetPassword properties must be specified if the SQL Server Compact Edition Server Agent is configured to use Basic or Integrated Authentication.

Syntax

object.Pull (localTableName, sqlSelectString, oledbConnectionString,  RDA_TRACKOPTION, ErrorTableName)

Parameters

  • LocalTableName
    The name of the SQL Server Compact Edition table that receives the extracted SQL Server records. An error occurs if the table already exists.
  • SQLSelectString
    A string that specifies which table, columns, and records to extract from the SQL Server database and store in the SQL Server Compact Edition database. This string can be any valid SQL statement that returns rows, including SELECT statements or stored procedures.
  • RDA_TRACKOPTION
    The RDA_TRACKOPTION enumeration indicates whether to track changes made to the pulled table. When indexes are requested, indexes that exist on the table being pulled are brought down to the device with the PRIMARY KEY constraints. For more information, see RDA_TRACKOPTION.
  • ErrorTableName
    The name of the local error table that is created if an error occurs when the Push method is later called to send changes back to SQL Server. This option can be specified only when RDA_TRACKOPTION is set to TRACKINGON.

Applies To

SQL Server Compact Edition RemoteDataAccess object

Remarks

SQLSelectString

The SQLSelectString parameter controls which data is pulled from the SQL Server table. Consider the following when you use the SQLSelectString parameter:

  • The SQLSelectString parameter can specify a WHERE clause to control which records are returned. For example, SELECT * FROM Address WHERE PostalCode='93868' retrieves addresses for the specified postal code only.
  • SQLSelectString supports stored procedures and views that return rows.
  • SQLSelectString can pull selected columns from multiple tables into a single table, but only if the RDA_TRACKOPTION parameter is set to TRACKINGOFF.
  • An error occurs if the resulting recordset contains an unsupported data type, such as timestamp.

ErrorTableName

The ErrorTableName parameter specifies the name of the table in which errors that occur during a push will be stored. If an error occurs when the application calls the Push method, SQL Server Compact Edition creates the error table and adds a record to the table for each error that occurs. When the Push method finishes, the application can examine the error table to determine whether errors have occurred. ErrorTableName can be specified only when either TRACKINGON or TRACKINGONWITHINDEXES is specified. For more information about how the error table works, see RDA Conflict Detection and Reporting.

See Also

Reference

RDA Object Methods
Push Method (RDA)

Help and Information

Getting SQL Server Compact Edition Assistance