on 2021 Jul 21 11:46 PM
Buenas estimados tengo una consulta, con éxito he logrado el agregado y consulta a la tabla definida por usuarios,

1. Consulta del registro , Funciona Bien
2. Selección el CheckBox, Funciona Bien
3. Actualizar solo lo que el checkBox en la tabla definida por usuario.
private SAPbouiCOM.Button Button6;
private void Button6_ClickBefore(object sboObject, SAPbouiCOM.SBOItemEventArg pVal, out bool BubbleEvent)
{
BubbleEvent = true;
//throw new System.NotImplementedException();
if (oform.Mode == SAPbouiCOM.BoFormMode.fm_UPDATE_MODE)
{
for (int i = 0; i < oRset.RecordCount; i++)
{
oUserTable = oCompany.UserTables.Item("CONCILIACION");
oUserTable.UserFields.Fields.Item("U_EstadoConciliado").Value = ((SAPbouiCOM.CheckBox)Matrix1.Columns.Item("Col_6").Cells.Item(i + 1).Specific).Checked ? ((SAPbouiCOM.CheckBox)Matrix1.Columns.Item("Col_6").Cells.Item(i + 1).Specific).ValOn.ToString() : ((SAPbouiCOM.CheckBox)Matrix1.Columns.Item("Col_6").Cells.Item(i + 1).Specific).ValOff.ToString();
int r = oUserTable.Update();
if (r != 0)
{
OApp.SetStatusBarMessage("Error" + oCompany.GetLastErrorDescription(), SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
else
{
OApp.SetStatusBarMessage("sucessfully update", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
}
}
Request clarification before answering.
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.