(ODBC Manager Library)
| Description: | Synchronizes the fields matching a specified criteria within matching tables in two databases. Should be run as a called module, waiting for completion. Do not call as a subroutine. |
| Returns: | Nothing |
Usage:  |
Script Only. |
| Function Groups: | ODBC |
| Related to: | AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbDate | ConvertToDbTime | ConvertToDbTimeStamp | ConvertToVTSDate | ConvertToVTSTime | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCached | FlushCache | FormatBatchQuery | GetConnList | ResultFormat | StatsWin | Transaction | TransactionCached |
| Format: |
\ODBCManager\TableSynch( DSNSource, DSNDest, TableName, WhereFields, WhereOperators, WhereValues, WhereSQLDataTypes, WhereAND, SourceUsername, SourcePass, DestUsername, DestPass, [ TransObj,] NRecords, CurrRecord) |
| Parameters: |
| DSNSource |
| Required. Data source name of the database to retrieve data from. |
| DSNDest |
| Required. Data source name of the destination database to send data to |
| TableName |
| Required. Table name to read/write in both databases |
| WhereFields |
| Required. A text array of field names to select using an SQL WHERE clause |
| WhereOperators |
| Required. A text array of operators to use when selecting fields using an SQL WHERE clause |
| WhereValues |
| Required. A text array of values to use when selecting the above fields using an SQL WHERE clause |
| WhereSQLDataTypes |
| Required. Values indicating the data type of the Where values. Should be a simple value or an array matching the WhereFields parameter. Refer to Data Type Codes used in the ODBC Manager for a list of the codes. |
| WhereAND |
| Required. Set to true (1) if the fields in the SQL WHERE clause are to be AND'ed. Otherwise, OD'ed |
| SourceUsername |
| Required. User name for source db |
| SourcePass |
| Required. A password for source db |
| DestUsername |
| Required. A user name for destination db |
| DestPass |
| Required. A password for destination db |
| TransObj |
| The object value of transaction |
| NRecords |
| Required. A number of records to synchronize |
| CurrRecord |
| Required. Current record being written |
| Comments: | This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above. |
