Tutorial by Examples: g

SQL has two logical functions – CHOOSE and IIF. The CHOOSE function returns an item from a list of values, based on its position in the list. This position is specified by the index. In the syntax, the index parameter specifies the item and is a whole number, or integer. The val_1 … val_n paramete...

Try catch Errors must always be handled. If you are using synchronous programming you could use a try catch. But this does not work if you work asynchronous! Example: try { setTimeout(function() { throw new Error("I'm an uncaught error and will stop the server!"); }, 1...

Progress supports one dimensional arrays, but they are called EXTENTS. /* Define a character array with the length 5, and display it's length */ DEFINE VARIABLE a AS CHARACTER EXTENT 5 NO-UNDO. DISPLAY EXTENT(a). Individual positions i the array is accessed using "standard" c-style b...

camel_case() This method changes a string to camel case camel_case('hello_world'); result HelloWorld

The useGravity property of a RigidBody controls whether gravity affects it or not. If set to false the RigidBody will behave as if in outer space (without a constant force being applied to it in some direction). GetComponent<RigidBody>().useGravity = false; It is very useful in the situati...

First, Go to Tools > NuGet Package Manager > Package Manager Console. Enter this Command "Install-Package Plugin.Facebook" in Package Manger Console. Now all the file is automatically created. Video : Login with Facebook in Xamarin Forms Other Authentication by using Pl...

When you have defined the basic layout of the application and acquired necessary permissions, the final step is to initialize the instance of the MapFragment class, thus creating and associating a Map with the MapFragment declared in the activity_main.xml file. public class BasicMapActivity extends...

When using the Oozie Proxy job submission API for submitting the Oozie Hive, Pig, and Sqoop actions. To pass any configuration to the action, is required to be in below format. For Hive action: oozie.hive.options.size : The number of options you'll be passing to Hive action. oozie.hive.options....

Before we use the IncludeFile method, we need to : Declare std_internal_LibFiles globally Initialize it with a new dictionary Dim std_internal_LibFiles Set std_internal_LibFiles = CreateObject("Scripting.Dictionary")

Bokeh's Docs on Installation Bokeh runs on Python it has the following dependencies; NumPy, Jinja2, Six, Requests, Tornado >= 4.0, PyYaml, DateUtil If you plan on installing with Python 2.7 you will also need future. All of those come with the Anaconda Python Distribution. Which you can downl...

Use browser.driver instead of driver Use browser.driver.ignoreSynchronization = true Reason: Protractor waits for angular components to load completely on a web-page befor it begins any execution. However, since our pages are non-angular, Protractor keeps waiting for 'angular' to load till the tes...

Install-Package MailKit

using MailKit.Net.Smtp; using MimeKit; using MimeKit.Text; using System.Threading.Tasks; namespace Project.Services { /// Using a static class to store sensitive credentials /// for simplicity. Ideally these should be stored in /// configuration files public static class C...

ng-view is a directive used with $route to render a partial view in the main page layout. Here in this example, Index.html is our main file and when user lands on "/" route the templateURL home.html will be rendered in Index.html where ng-view is mentioned. angular.module('ngApp', ['ngRou...

Array Implementation #include<stdio.h> #define MAX 100000 //Global variables int top = -1; int a[MAX]; void push(int x){ if(top == MAX-1){ // Check whether stack is full printf("Stack Overflow\n"); retur...

The most common way to add (and edit classes) in from the system browser In the Nautilus system browser have nothing selected or select a package (first column) or a class (second column). Depending on the selection, the code editor will display a slightly different class template: SelectionTemplat...

From VBA array sort function? Public Sub QuickSort(vArray As Variant, inLow As Long, inHi As Long) Dim pivot As Variant Dim tmpSwap As Variant Dim tmpLow As Long Dim tmpHi As Long tmpLow = inLow tmpHi = inHi pivot = vArray((inLow + inHi) \ 2) While (tmpLow <=...

This code takes advantage of the Sort class in the Microsoft Excel Object Library. For further reading, see: Copy a range to a virtual range How to copy selected range into given array? Sub testExcelSort() Dim arr As Variant InitArray arr ExcelSort arr End Sub Private Su...

From anywhere in Vim, execute :help :help. This will open a horizontally split window with the manual page for the :help command. :help by itself will take you to the Table of Contents for the manual itself. Vim's help files are navigable like regular files (you can search for keywords within a fil...

:help [subject] attempts to find the "best" match for the argument you supply. The argument "can include wildcards like *, ? and [a-z] (any letter). You can additionally use Vim's command-line completion with CTRL+D: :help spli<Ctrl-D> will display a list of help topics matchi...