Tutorial by Examples: e

All we need are: ViewPager, TabLayout and 2 drawables for selected and default dots. Firstly, we have to add TabLayout to our screen layout, and connect it with ViewPager. We can do this in two ways: Nested TabLayout in ViewPager <android.support.v4.view.ViewPager android:id="@+i...

Service: angular.module('core').factory('print_service', ['$rootScope', '$compile', '$http', '$timeout','$q', function($rootScope, $compile, $http, $timeout,$q) { var printHtml = function (html) { var deferred = $q.defer(); var hiddenFrame = $('<...

To publish a crate on crates.io, you must log in with Cargo (see 'Connecting Cargo to a Crates.io Account'). You can package and publish your crate with the following commands: cargo package cargo publish Any errors in your Cargo.toml file will be highlighted during this process. You should en...

Accounts on crates.io are created by logging in with GitHub; you cannot sign up with any other method. To connect your GitHub account to crates.io, click the 'Login with GitHub' button in the top menu bar and authorise crates.io to access your account. This will then log you in to crates.io, assumi...

Although storing multiple values in a single column violates normalization rules, sometimes one has to deal with badly designed legacy tables. A recursive query can help convert comma-separated values into distinct rows. Create a sample badly designed table and insert some data: create table proje...

The default way to find installed packages with CMake is the use the find_package function in conjunction with a Find<package>.cmake file. The purpose of the file is to define the search rules for the package and set different variables, such as <package>_FOUND, <package>_INCLUDE_D...

On Unix-like operating systems, it is possible to use the pkg-config program to find and configure packages that provides a <package>.pc file. In order to use pkg-config, it is necessary to call include(FindPkgConfig) in a CMakeLists.txt. Then, there are 2 possible functions: pkg_search_mo...

String macros do not come with built-in interpolation facilities. However, it is possible to manually implement this functionality. Note that it is not possible to embed without escaping string literals that have the same delimiter as the surrounding string macro; that is, although ""&quot...

Adding a Product to a Shopping Cart The following example demonstrates how to Add a product (or anything) to a Database Table asynchronously, using AJAX, and TypeScript. declare var document; declare var xhr: XMLHttpRequest; window.onLoad = () => { Start(); }; function Start() { ...

To give an alert close functionality, all we need is to add data-dismiss="alert" to our close button. <div class="alert alert-info alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria...

Detailed instructions on getting swt set up or installed.

Detailed instructions on getting encoding set up or installed.

The reduce(), reduceLeft() and reduceRight methods are similar to folds. The function passed to reduce takes two values and yields a third. When operating on a list, the first two values are the first two values in the list. The result of the function and the next value in the list are then re-appli...

Outer joins return all the rows from one or both tables, plus matching rows. Table People PersonID FirstName 1 Alice 2 Bob 3 Eve Table Scores PersonID Subject Score 1 Math 100 2 Math 54 2 Science 98 Left joining the tables: Select * f...

This simple function will execute the specified Select SQL command and return the result as data set. Public Function ReadFromDatabase(ByVal DBConnectionString As String, ByVal SQL As String) As DataTable Dim dtReturn As New DataTable Try 'Open the connection using the connection...

This example uses the Thread Class, but multithreaded applications can also be made using BackgroundWorker. The AddNumber, SubstractNumber, and DivideNumber functions will be executed by separate threads: Edit: Now the UI thread waits for the child threads to finish and shows the result. Module Mo...

Unlike a SELECT statement, a Stored Procedure returns multiple result sets. The requires different code to be used for gathering the results of a CALL in Perl, PHP, etc. (Need specific code here or elsewhere!)

Data not yet known - such as end_date, rating Optional data - such as middle_initial (though that might be better as the empty string) 0/0 - The result of certain computations, such as zero divided by zero. NULL is not equal to "" (blank string) or 0 (in case of integer). others? ...

Using the /p switch with the SET command you can define variables from an Input. This input can be a user Input (keyboard) : echo Enter your name : set /p name= echo Your name is %name% Which can be simplified like this : set /p name=Enter your name : echo Your name is %name% Or you can...

IS NULL / IS NOT NULL -- = NULL does not work like you expect. x <=> y is a "null-safe" comparison. In a LEFT JOIN tests for rows of a for which there is not a corresponding row in b. SELECT ... FROM a LEFT JOIN b ON ... WHERE b.id IS NULL