Tutorial by Examples: w

Widening and Narrowing

Needs editing.

Visual Basic .NET Language • Operators

Stored procedure with IN, OUT, INOUT parameters

DELIMITER $$ DROP PROCEDURE IF EXISTS sp_nested_loop$$ CREATE PROCEDURE sp_nested_loop(IN i INT, IN j INT, OUT x INT, OUT y INT, INOUT z INT) BEGIN DECLARE a INTEGER DEFAULT 0; DECLARE b INTEGER DEFAULT 0; DECLARE c INTEGER DEFAULT 0; WHILE a < i DO WHILE b <...

MySQL • Stored routines (procedures and functions)

Overview

Composer is a tool for dependency management in PHP. It allows you to declare the libraries your project depends on and it will manage (install/update) them for you. Composer is not a package manager in the same sense as Yum or Apt are. Yes, it deals with "packages" or libraries, but it m...

composer-php • Getting started with composer-php

Casting away constness

A pointer to a const object can be converted to a pointer to non-const object using the const_cast keyword. Here we use const_cast to call a function that is not const-correct. It only accepts a non-const char* argument even though it never writes through the pointer: void bad_strlen(char*); const...

C++ • Explicit type conversions

Searching for the word under the cursor

In normal mode, move the cursor to any word then press * to search forwards for the next occurrence of the word under the cursor, or press # to search backwards. * or # search for the exact word under the cursor: searching for big would only find big and not bigger. Under the hood, Vim uses a sim...

vim • Searching in the current buffer

Opening a new split window

You can open a new split within Vim with the following commands, in normal mode: Horizontally: :split <file name> :new Vertically: :vsplit <file name> :vnew split will open the file in a new split at the top or left of your screen (or current split.) :sp and :vs are convenie...

vim • Split windows

Wait for DOM to be loaded

Use DOMContentLoaded when the <script> code interacting with DOM is included in the <head> section. If not wrapped inside the DOMContentLoaded callback, the code will throw errors like Cannot read something of null document.addEventListener('DOMContentLoaded', function(event) { ...

DOM • Getting started with DOM

Extending Rectangle adding new stylable properties

JavaFX 8 The following example demonstrates how to add custom properties that can be styled from css to a custom Node. Here 2 DoublePropertys are added to the Rectangle class to allow setting the width and height from CSS. The following CSS could be used for styling the custom node: StyleableRe...

javafx • CSS

Connection to a Microsoft Access database with UCanAccess

UCanAccess is a pure Java JDBC driver that allows us to read from and write to Access databases without using ODBC. It uses two other packages, Jackcess and HSQLDB, to perform these tasks. Once it has been set up*, we can work with data in .accdb and .mdb files using code like this: import java.sq...

jdbc • Creating a database connection

How to configure build types in the build.gradle

You can create and configure build types in the module-level build.gradle file inside the android {} block. android { ... defaultConfig {...} buildTypes { release { minifyEnabled true proguardFiles getDefaultProguar...

android-gradle • Configure Build Types

TwoThreeShape

a simple example of how to define a custom shape with 2 inlets and 3 outlets. case class TwoThreeShape[-In1, -In2, +Out1, +Out2, +Out3]( in1: Inlet[In1@uncheckedVariance], in2: Inlet[In2@uncheckedVariance], out1: Outlet[Out1@uncheckedVariance], out2: Ou...

akka • akka-streams custom shapes

Worksheet .Name, .Index or .CodeName

We know that 'best practise' dictates that a range object should have its parent worksheet explicitly referenced. A worksheet can be referred to by its .Name property, numerical .Index property or its .CodeName property but a user can reorder the worksheet queue by simply dragging a name tab or rena...

excel-vba • Excel VBA Tips and Tricks

Akka hello world (Scala)

Add akka-actor dependency (SBT example) libraryDependencies += "com.typesafe.akka" % "akka-actor_2.11" % "2.4.8" Create actor classes: Actor for string output: class OutputActor extends Actor { override def receive: Receive = { case message => p...

akka • Hello world

Always define and set references to all Workbooks and Sheets

When working with multiple open Workbooks, each of which may have multiple Sheets, it’s safest to define and set reference to all Workbooks and Sheets. Don't rely on ActiveWorkbook or ActiveSheet as they might be changed by the user. The following code example demonstrates how to copy a range from...

excel-vba • VBA Best Practices

Show help file

The Help Class encapsulates the HTML Help 1.0 engine. You can use the Help object to show compiled Help files (.chm) or HTML files in the HTML Help format. Compiled Help files provide table of contents, index, search, and keyword links in pages. Shortcuts work only in compiled Help files. You can ge...

winforms • Help Integration

Delete row(s) from the table

To delete all rows from the table //get writable database SQLiteDatabase db = openHelper.getWritableDatabase(); db.delete(TABLE_NAME, null, null); db.close(); To delete all rows from the table and get the count of the deleted row in return value //get writable database SQLiteDatabase db =...

Android • SQLite

Ubuntu Installation via Manual Download and Configuration

Download your preferred version from Lightbend with curl: curl -O http://downloads.lightbend.com/scala/2.xx.x/scala-2.xx.x.tgz Unzip the tar file to /usr/local/share or /opt/bin: unzip scala-2.xx.x.tgz mv scala-2.xx.x /usr/local/share/scala Add the PATH to ~/.profile or ~/.bash_profile or ...

Scala Language • Setting up Scala

Create a Copy of an Object with Certain Changes

Case classes provide a copy method that creates a new object that shares the same fields as the old one, with certain changes. We can use this feature to create a new object from a previous one that has some of the same characteristics. This simple case class to demonstrates this feature: case cla...

Scala Language • Case Classes

Hello World

Requirements A version of the Haxe toolkit must be installed Haxe must be present in your system path Command line must be accessible Code Navigate to a desired project directory and create a Test.hx source file with the following content: class Test { static function main() { ...

haxe • Getting started with haxe

Connect with WEP encryption

This example connects to a Wi-Fi access point with WEP encryption, given an SSID and the password. public boolean ConnectToNetworkWEP(String networkSSID, String password) { try { WifiConfiguration conf = new WifiConfiguration(); conf.SSID = "\"" + networkSSID ...

Android • Wi-Fi Connections