Tutorial by Examples: b

The PXDBDateAndTime attribute and the PXDateAndTime attribute are designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store both date and time value parts inside a single field: #region UsrDateAndTime public abstract class usrDateAndTimeAttribute : IBqlField { }...

The PXDBTime attribute is designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store only the time part without date inside a DAC field: #region UsrTime public abstract class usrTime : IBqlField { } [PXDBTime(DisplayMask = "t", InputMask = "t&qu...

The PXDBDate attribute and the PXDate attribute are designed to work with a DAC field of the Nullable<DateTime> (DateTime?) type and store date value with an optional time part inside a single field. Wheather PX(DB)DateAttribute should save time in addition to date in a DAC field is defined by...

The PXDBTimeSpan attribute is designed to work with a DAC field of the Nullable<int> (int?) type and store time value inside a DAC field as the number of minutes passed since midnight: #region UsrTimeInt public abstract class usrTimeInt : IBqlField { } [PXDBTimeSpan(DisplayMask = "t...

The PXTimeList attribute is designed to work with a DAC field of the Nullable<int> (int?) type and store time span value inside a DAC field as a number of minutes: #region UsrTimeSpan public abstract class usrTimeSpan : IBqlField { } [PXDBInt] [PXTimeList] [PXUIField(DisplayName = &quo...

This is a weird approach most of the people don't know this even exist. CREATE TABLE AliasNameDemo(id INT,firstname VARCHAR(20),lastname VARCHAR(20)) INSERT INTO AliasNameDemo VALUES (1,'MyFirstName','MyLastName') SELECT * FROM (SELECT firstname + ' ' + lastname FROM A...

1. For Loop: CountriesName = ["India", "Canada", "America", "Iraq"] for country in CountriesName puts country end 2. Each Iterator: Same set of work can be done with each loop which we did with for loop. CountriesName = ["India", "C...

The ObservableObject class contains some helpful methods to help with the MVVM pattern. The RaisePropertyChanged provides a compile safe method to raise property changed events. It can be called with RaisePropertyChanged(() => MyProperty); The Set method can be used in the property setter t...

ViewModelBase extends ObservableObject and adds some methods useful for viewmodels. The property IsInDesignMode or IsInDesignModeStatic allows to determine if the code is executed in the design mode (in Visual Studio Design View) or not. The two properties are exactly the same.

Tables are most easily included with the DT package, which is an R interface to the JavaScript library DataTables. library(shiny) library(DT) ui <- fluidPage( dataTableOutput('myTable') ) server <- function(input, output, session){ output$myTable <- renderDataTable({ dat...

An observeEvent object can be used to trigger a piece of code when a certain event occurs. It is constructed as: observeEvent( event { code to run }) The observeEvent will only be dependent on the 'event' section in the small piece of code above. It will not be dependent on anything in the 'co...

One can use the command-line launching facility is when one wants to customize some aspects of the way MySQL Workbench operates. MySQL Workbench has the following common command line options: --admin instance - Launch MySQL Workbench and load the server instance specified. --query connection - ...

An observe expression is triggered every time one of its inputs changes. The major difference with regards to a reactive expression is that it yields no output, and it should only be used for its side effects (such as modifying a reactiveValues object, or triggering a pop-up). Also, note that obser...

Using DOSKEY, we can create macros to simplify typing many commands in command prompt. Take a look at the following example. DOSKEY macro=echo Hello World Now if you type macro in the command prompt, it would return Hello World.

class AppDelegate: UIResponder, UIApplicationDelegate { var window: UIWindow? var firstTabNavigationController : UINavigationController! var secondTabNavigationControoller : UINavigationController! var thirdTabNavigationController : UINavigationController! var fourth...

For this, we will use the function aggregate, which can be used as follows: aggregate(formula,function,data) The following code shows various ways of using the aggregate function. CODE: df = data.frame(group=c("Group 1","Group 1","Group 2","Group 2",&quo...

Sometimes the download takes longer than the cell is being displayed. In this case it can happen, that the downloaded image is shown in the wrong cell. To fix this we can not use the UIImageView Extension. We still will be using Alamofire however we will use the completion handler to display the im...

Use .outerHTML to get the HTML Here is a code sample to get the entire HTML of the website private async void GetHTMLAsync() { var siteHtML = await webView.InvokeScriptAsync("eval", new string[] { "document.documentElement.outerHTML;" }); }

Use .innerText to set the value Here is a code sample to enter text in Search Box on Bing website private async void EnterTextAsync(string enterText) { var functionString = string.Format(@"document.getElementsByClassName('b_searchbox')[0].innerText = '{0}';", enterText); await...

Use .click() to simulate click Here is a code sample to click search button on Bing website private async void SimulateClickAsync() { var functionString = string.Format(@"document.getElementsByClassName('b_searchboxSubmit')[0].click();"); await webView.InvokeScriptAsync("...