ADO MarshalOptions Property

The MarshalOptions property sets or returns one of the MarshalOptionsEnum constants that dictates whether all or just the modified records will be marshaled (transferred) from the client to the server. The default is to marshal all.

Syntax

objRecordset.MarshalOptions

Example



				If objRecordset.MarshalOptions 
				= adMarshallModifiedOnly Then

				   objRecordset.Update

				   MsgBox "Only Modified Records Were Returned to Server", vbOK

				Else

				   objRecordset.Update

				   MsgBox "All Records Were Returned to Server", vbOK

				End If

Explanation:
In this example, only the first five records are returned even though the query string selects all records in the table.

MarshalOptionsEnum Values

Constant	Value	Description
adMarshalAll	0	Default. Returns all rows
adMarshalModifiedOnly	1	Returns only modified rows