Tutorial by Examples: el

Inheriting fields from a class

Defining the base class: open class BaseClass { val x = 10 } Defining the derived class: class DerivedClass: BaseClass() { fun foo() { println("x is equal to " + x) } } Using the subclass: fun main(args: Array<String>) { val derivedClass = Deri...

Bit-field alignment

Bit-fields give an ability to declare structure fields that are smaller than the character width. Bit-fields are implemented with byte-level or word-level mask. The following example results in a structure of 8 bytes. struct C { short s; /* 2 bytes */ char c; /* 1 ...

Stored Procedure with If...Else and Insert Into operation

Create example table Employee: CREATE TABLE Employee ( Id INT, EmpName VARCHAR(25), EmpGender VARCHAR(6), EmpDeptId INT ) Creates stored procedure that checks whether the values passed in stored procedure are not null or non empty and perform insert operation in Employee ta...

Enforce minimum version of powershell host

#requires -version 4 After trying to run this script in lower version, you will see this error message .\script.ps1 : The script 'script.ps1' cannot be run because it contained a "#requires" statement at line 1 for Windows PowerShell version 5.0. The version required by the script do...

Simple D3 Chart: Hello World!

Paste this code into an empty HTML file and run it in your browser. <!DOCTYPE html> <body> <script src="https://d3js.org/d3.v4.js"></script> <!-- This downloads d3 library --> <script> //This code will visualize a data set as a simple scatt...

Updating the Help System

3.0 Beginning with PowerShell 3.0, you can download and update the offline help documentation using a single cmdlet. Update-Help To update help on multiple computers (or computers not connected to the internet). Run the following on a computer with the help files Save-Help -DestinationPath ...

Using Get-Help

Get-Help can be used to view help in PowerShell. You can search for cmdlets, functions, providers or other topics. In order to view the help documentation about jobs, use: Get-Help about_Jobs You can search for topics using wildcards. If you want to list available help topics with a title start...

Viewing online version of a help topic

You can access online help documentation using: Get-Help Get-Command -Online

Viewing the Full Help Page

View the full documentation for the topic. Get-Help Get-Command -Full

Simple Application Object example: Minimize the Excel window

This code uses the top level Application object to minimize the main Excel window. Sub MinimizeExcel() Application.WindowState = xlMinimized End Sub

Viewing help for a specific parameter

You can view help for a specific parameter using: Get-Help Get-Content -Parameter Path

Find the Last Non-Empty Column in Worksheet

Private Sub Get_Last_Used_Row_Index() Dim wS As Worksheet Set wS = ThisWorkbook.Sheets("Sheet1") Debug.Print LastCol_1(wS) Debug.Print LastCol_0(wS) End Sub You can choose between 2 options, regarding if you want to know if there is no data in the worksheet :...

Ways to refer to a single cell

The simplest way to refer to a single cell on the current Excel worksheet is simply to enclose the A1 form of its reference in square brackets: [a3] = "Hello!" Note that square brackets are just convenient syntactic sugar for the Evaluate method of the Application object, so technicall...

Saving a reference to a cell in a variable

To save a reference to a cell in a variable, you must use the Set syntax, for example: Dim R as Range Set R = ActiveSheet.Cells(3, 1) later... R.Font.Color = RGB(255, 0, 0) Why is the Set keyword required? Set tells Visual Basic that the value on the right hand side of the = is meant to be ...

Union Types in C# can also contain Struct fields

Apart from primitives, the Explicit Layout structs (Unions) in C#, can also contain other Structs. As long as a field is a Value type and not a Reference, it can be contained in a Union: using System; using System.Runtime.InteropServices; // The struct needs to be annotated as "Explici...

Creating a self-signed code signing certificate for testing

When signing personal scripts or when testing code signing it can be useful to create a self-signed code signing certificate. 5.0 Beginning with PowerShell 5.0 you can generate a self-signed code signing certificate by using the New-SelfSignedCertificate-cmdlet: New-SelfSignedCertificate -Friendl...

Import New as well as Updated Data - lastmodified mode

If you are adding new rows and updating existing data. You need two additional parameters: --check-column : A column name that should be checked for newly appended and updated data. date, time, datetime and timestamp are suitable data types for this column. --last-value : The last value that su...

Levels of declaration – Local and Member variables

Local variables - Those declared within a procedure (subroutine or function) of a class (or other structure). In this example, exampleLocalVariable is a local variable declared within ExampleFunction(): Public Class ExampleClass1 Public Function ExampleFunction() As Integer Dim exa...

Reload ZSH Configuration

zsh loads configuration from the ~/.zshrc file on startup. If you make changes to that file, you can either restart zsh or run the following command to reload the configuration. . ~/.zshrc You can alias this useful command in your ~/.zshrc like this: alias reload=". ~/.zshrc"

Minimal "Hello World" with pthreads

#include <pthread.h> #include <stdio.h> #include <string.h> /* function to be run as a thread always must have the same signature: it has one void* parameter and returns void */ void *threadfunction(void *arg) { printf("Hello, World!\n"); /*printf() is speci...

Page 83 of 145

logo rip
SUPPORT & PARTNERS
STAY CONNECTED

Get monthly updates about new articles, cheatsheets, and tricks.