Hi Raja ,,
use this code
For modifying a particular Sync Bo instance ,
for example modifying the header ,
first u have to find ou the particular Sync Bo Instance.
for this u need sync key of that particular sync bo instance ..
anyway if you are going for modification , then u will have the
synckey for that instance .
using this sync key ,
u can find out the sync bo instance in this way..
SyncBoDescriptor sbd = descriptorFacade.getSyncBoDescriptor(<syncBoName>);
SyncBo sb = null;
try {
sb = dataFacade.getSyncBo(sbd,<syncKey>);
} catch (PersistenceException pex) {
}
so we have the particular sync bo instance..
SmartSyncTransactionManager transactionManager;
transactionManager = dataFacade.getSmartSyncTransactionManager();
if (!transactionManager.isTransactionStarted())
transactionManager.beginTransaction();
// then use the setHeaderFieldValue method in the SmartSyncDB Access.
setHeaderFieldValue(sb,<header field Name>,<value>);
//Commit the transaction
transactionManager.commit();
*******************************************************************************
// Method to set the value in header .. in this some exceptions are also handled.. u can use this method
public boolean setHeaderFieldValue(
SyncBo sb,
String headerFieldName,
Object value) {
SyncBoDescriptor sbd = sb.getSyncBoDescriptor();
RowDescriptor trd = sbd.getTopRowDescriptor();
FieldDescriptor fd = trd.getFieldDescriptor(headerFieldName);
if (fd != null) {
BasisFieldType bft = fd.getFieldType();
Row header = sb.getTopRow();
try {
// Integer operator
if (bft == BasisFieldType.N) {
NumericField nf = header.getNumericField(fd);
if (nf != null) {
BigInteger ii = new BigInteger(value.toString());
nf.setValue(ii);
return true;
} else {
return false;
}
}
// Character operator
if (bft == BasisFieldType.C) {
CharacterField cf = header.getCharacterField(fd);
if (cf != null) {
cf.setValue(value.toString());
return true;
} else {
return false;
}
}
// Decimal operator
if (bft == BasisFieldType.P) {
DecimalField df = header.getDecimalField(fd);
if (df != null) {
BigDecimal bd = new BigDecimal(value.toString());
df.setValue(bd);
return true;
} else {
return false;
}
}
// Similar operation for time and date operator fields
if (bft == BasisFieldType.D) {
DateField df = header.getDateField(fd);
if (df != null) {
if (value.toString().equals("0")) {
Date dat = Date.valueOf("0000-00-00");
df.setValue(dat);
} else if (!value.toString().equals("")) {
Date dat = Date.valueOf(value.toString());
df.setValue(dat);
} else {
Calendar cal = Calendar.getInstance();
java.sql.Date bd =
new java.sql.Date(cal.getTime().getTime());
df.setValue(bd);
}
return true;
} else {
return false;
}
}
// Similar operation for time and date operator fields
} catch (SmartSyncException ex) {
System.out.println(ex.getMessage());
} catch (PersistenceException e) {
System.out.println(e.getMessage());
}
}
return false;
}
let me know , if u have doubts..
Regards
Kishor Gopinathan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.