Monday, August 31, 2020

Convert JD Edwards Julian date to calendar date PL SQL

Convert JD Edwards Julian date to calendar date SELECT TO_CHAR(TO_DATE(Y$CKDT+1900000, 'YYDDD'), 'MM/DD/YYYY') as CheckDate, F1.* FROM PRODDTA.F0719 F1

Tuesday, August 18, 2020

Checkbox Click Event Sencha Ext JS

{

                        xtype: 'checkboxfield',

                        boxLabel: 'All Municipal',

                        name: 'AllMunicipal',

                        margin: '0 0 0 0',

                        listeners: {

                              change: function (checkbox, newVal, oldVal) {

                                  if (newVal == '1' && oldVal == '0') {

                                      var allCheckBoxes = checkbox.up('checkboxgroup').items.items;

                                      for (var i = 0; i < allCheckBoxes.length; i++) {

                                          allCheckBoxes[i].setValue('1');

                                      }

                                  }

                              }

                          }

                    }

 

 

https://forum.sencha.com/forum/showthread.php?137463-Checkbox-Click-Event

 



Monday, August 17, 2020

Recordset RecordCount VBA C# .net

Sometime we have to count record set and take decision wheather to show result in excel or not. If count is too much excel can crash. for that people are running same query two times, one time count and another time display record. In order to avoid this run query onece and take decision. like following:- If Recordset.RecordCount > 20000 Then Response = MsgBox(WorksheetFunction.text(Recordset.RecordCount, "_(* #,##0_);_(* (#,##0);_(* ""-""??_);_(@_)") & "Records......Continue?", vbYesNo) If Response = vbNo Then GoTo CleanUp_Exit End If https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-recordcount-property-dao