|
Home > Archive > SQL Anywhere Mobile > March 2005 > Remote RI overrides TableOrder in 9.0.2.2551
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Remote RI overrides TableOrder in 9.0.2.2551
|
|
| Breck Carter [TeamSybase] 2005-03-30, 9:43 am |
| There might as well be no TableOrder option, if dbmlsync is going to
give a Catch-22 error message like this:
E. 03/09 16:01:27. TableOrder option violates RI constraints. Table
'xxx' must come before table 'yyy'.
How does dbmlsync KNOW that the TableOrder option violates RI
constraints ON THE CONSOLIDATED DATABASE? (shouting intended)
Those are the only constraints that matter here, NOT THE REMOTE RI
constraints.
Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Graham Hurst 2005-03-30, 9:43 am |
| Noted. Thanks Breck.
Cheers,
Graham
Breck Carter [TeamSybase] wrote:
> There might as well be no TableOrder option, if dbmlsync is going to
> give a Catch-22 error message like this:
>
> E. 03/09 16:01:27. TableOrder option violates RI constraints. Table
> 'xxx' must come before table 'yyy'.
>
> How does dbmlsync KNOW that the TableOrder option violates RI
> constraints ON THE CONSOLIDATED DATABASE? (shouting intended)
>
> Those are the only constraints that matter here, NOT THE REMOTE RI
> constraints.
>
> Breck
| |
| Graham Hurst 2005-03-30, 9:43 am |
| FYI, the Jasper version will have a TableOrderChecking option to let you
disable this checking when your consolidated RI differs from your remote RI.
Cheers,
Graham
Graham Hurst wrote:[color=darkred
]
> Noted. Thanks Breck.
>
> Cheers,
>
> Graham
>
> Breck Carter [TeamSybase] wrote:
>
|
|
|
|
|