Questions on publications and their defined columns - 07-05-2006 , 11:30 AM
Can a publication NOT include a column yet be referenced by the
publication's WHERE clause?
If so, will an UPDATE to the data in this column cause the row to be
included in the transaction log?
One more question, can a publication's WHERE clause use IN with a variable?
If so, how would this be set up to work? variable type, where defined,
where populated with a list, ...
Re: Questions on publications and their defined columns - 07-05-2006 , 02:10 PM
Answers in-line below.
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/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"Bob" <email (AT) place (DOT) com> wrote
create publication p1 (
table t1 ( pkey,c1,c2 ) where c3=1
your question is whether an update to the data in the c3 column (using the
above example) will result in the operation in the transaction log being
marked for synchronization. The answer depends on how the data is modified.
If the value of the c3 column changes such that the row used to match the
where clause but no longer does, or did not used to meet the where clause
but now does, then the operation will be marked for synchronization, but an
update will not be sent. If the value of c3 changes TO the value "1", then
an insert of the entire row is synchronized to MobiLink. If the value of c3
changes FROM the value "1", then a delete of the row is synchronized to
clause, but variables cannot be used.
Re: Questions on publications and their defined columns - 07-05-2006 , 02:53 PM
Thank you for the answers, they help immensely.
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName (AT) ianywhere (DOT) com>
wrote in message news:44ac0ec1 (AT) forums-1-dub (DOT) ..