| Author |
referential integrity deletes
|
|
|
| Getting an I message in my syncing that some rows were deleted due to
referential integrity constraints...
One no rows are deleted in any remote but a column "deleted" is marked as
"Y".
So what could this mean and also how do I find out which rows were deleted?
It does not report the rows that were affected in the log for mlsync.
Thanks
ASA 9.02
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-07-28, 9:25 am |
| The rows are not reported, but the SQL that was executed to silently solve
RI violations should be printed to the dbmlsync output log.
You'll need to look into the ASA transaction log to see which rows were
actually deleted as a result of the SQL that was executed.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"MJN" < SpamFilterOnlychuck1
rar@yahoo.com> wrote in message
news:42e8df69$1@foru
ms-2-dub...
> Getting an I message in my syncing that some rows were deleted due to
> referential integrity constraints...
> One no rows are deleted in any remote but a column "deleted" is marked as
> "Y".
> So what could this mean and also how do I find out which rows were
deleted?
> It does not report the rows that were affected in the log for mlsync.
>
> Thanks
>
> ASA 9.02
>
>
| |
| Breck Carter [TeamSybase] 2005-07-28, 1:39 pm |
| In addition to what Reg suggested, check out the
sp_hook_dbmlsync_dow
nload_log_ri_violati
on procedure.
Breck
On 28 Jul 2005 06:36:45 -0700, "MJN"
< SpamFilterOnlychuck1
rar@yahoo.com> wrote:
>Getting an I message in my syncing that some rows were deleted due to
>referential integrity constraints...
>One no rows are deleted in any remote but a column "deleted" is marked as
>"Y".
>So what could this mean and also how do I find out which rows were deleted?
>It does not report the rows that were affected in the log for mlsync.
>
>Thanks
>
>ASA 9.02
>
--
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
|
|
|
|