DeletedStatement
The SQL statement to use to find deleted records when UseIncrementalStatements=True
.
When UseIncrementalStatements=True
, the connector runs the queries specified by InititalStatement
, AddedAndUpdatedStatement
and DeletedStatement
instead of the query specified by the SQL
parameter.
When UseIncrementalStatements=False
, this parameter is ignored.
The string @lastruntime
is replaced with the time of the last successful synchronize. The last run time is stored using GMT. If the dates in the database table differ from GMT, you can use the DATE_SUB()
and DATE_ADD()
functions to modify the last run time as required.
Type: | String |
Default: | |
Required: | No |
Configuration Section: | TaskName or FetchTasks |
Example: | DeletedStatement=select * from table where deleted=1
|
See Also: |