 | |
Questions on publications and their defined columns
sybase.public.sqlanywhere.mobilink sybase.public.sqlanywhere.mobilink
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Questions on publications and their defined columns -
07-05-2006
, 11:30 AM
#2
| ||||
| ||||
|
|
9.0.2.3274 Can a publication NOT include a column yet be referenced by the publication's WHERE clause? |
create publication p1 (
table t1 ( pkey,c1,c2 ) where c3=1
);
Quote:
|
If so, will an UPDATE to the data in this column cause the row to be included in the transaction log? |
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
MobiLink.
Quote:
|
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, ... |
clause, but variables cannot be used.
Quote:
|
TIA Bob |
#3
| |||
| |||
|
|
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 9.0.2.3274 Can a publication NOT include a column yet be referenced by the publication's WHERE clause? Yes. The following is possible : create publication p1 ( table t1 ( pkey,c1,c2 ) where c3=1 ); If so, will an UPDATE to the data in this column cause the row to be included in the transaction log? Every update on every table is included in the transaction log. I believe 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 MobiLink. 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, ... No, this is not currently possible. The where clause can contain the IN clause, but variables cannot be used. TIA Bob |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.