Tutorial by Examples: d

All images are from UK versions of Outlook. I know that some names are translated into the local language for other versions and I assume that most of the names for the tabs are translated. Probably the sequence of tabs is unchanged in non-English versions. Alternatively, you will need to look at yo...

All images in this section are from the UK version of Outlook 2016. I know that some names are translated into the local language for other versions and I assume that most of the names for the tabs are translated. Probably the sequence of tabs is unchanged in non-English versions. Alternatively, you...

The images in this section are all from Outlook 2016 but they could have come from Outlook 2003. Outlook VBA may have changed over the years but to my eyes the VBA Editor has not. Whichever version you have you will see something like: Above there is a “+” against "Project1". If you hav...

Did your version of Outlook need you to add the Development tab? If so, you will not need to repeat this process until you next have a new Outlook installation. Come back here when that happens. Remember how to enter the Visual Basic Editor. Remember how to create and rename a module.

Using LIKE you can base the definition of you variable on another variable or a field in a database or temp-table. Defining a variable LIKE a database field requiers the database to always be connected. This might not always be what you want. DEFINE VARIABLE i AS INTEGER NO-UNDO LABEL "Nr&quo...

The various parts of the introduction aim to give the information that any programmer new to Outlook VBA would need. Much of the code was originally developed with Outlook 2003 and has been tested with Outlook 2016. It should work unchanged with any intermediate version. New functionality has been...

In Swift, protocol extensions cannot have true properties. However, in practice you can use the "associated object" technique. The result is almost exactly like a "real" property. Here is the exact technique for adding an "associated object" to a protocol extension: ...

In this article we will use a simple database called “Company” with two tables: [dbo].[Categories]([CategoryID], [CategoryName]) [dbo].[Products]([ProductID], [CategoryID], [ProductName]) 1-1 Generate Entity Framework code In this layer we generate the Entity Framework code (in project library) ...

$username = 'user' $password= 'password' $DESTINATION = "D:\test\latest.tar.gz" $client = New-Object System.Net.WebClient $client.Credentials = new-object System.Net.NetworkCredential($username, $password) $lastModifiedResponse = $client.DownloadString('https://domain.org.com/artifact...

Here we are managing multiple collection there delegate methods with didselect events. extension ProductsVC: UICollectionViewDelegate, UICollectionViewDataSource{ // MARK: - UICollectionViewDataSource func collectionView(_ collectionView: UICollectionView, numberOfItemsI...

Every application needed to store User Session or User related details inside application in UserDefaults.So we made whole logic inside a Class for managing UserDefaults better way. Swift 3 import Foundation public struct Session { fileprivate static let defaults = UserDefaults.standard ...

1. Fetching the JSON response for last modified (latest) artifact latestArtifactUriResponse=curl -u username:password --silent https://hostname.com/artifactory/api/storage/<repo_name>/<folder_name>/?lastModified | grep uri | awk '{ print $3 }' | sed s/\"//g | sed s/,//g It will ...

The following server-side configuration allows CORS request to work along with Windows Authentication (no anonymous must be enabled in IIS). web.config - allow unauthenticated (anonymous) preflight requests (OPTIONS) <system.web> <authentication mode="Windows" /> &l...

The following example shows how to properly construct both GET and POST requests against Web API 2 (CORS must be configured server-side, if sent from another domain): <script type="text/javascript" src="https://code.jquery.com/jquery-3.1.1.js"></script> CORS with Wi...

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.6.1/angular.js"></script> CORS with Windows Authentication test (Angular) <script type="text/javascript"> var app = angular.module('myApp', []); app.c...

BEGINS - returns TRUE if one string begins with another string. string1 BEGINS string2 If string1 BEGINS with (or is equal to) string2 this will return true. Otherwise it will return false. If string two is empty ("") it will always return true. BEGINS is very useful in queries wher...

RANDOM - generates a random number RANDOM(low, high) Generates a pseudo random integer between low and high // Example that generates 20 random numbers between 1 and 20 (1 and 20 included) DEFINE VARIABLE i AS INTEGER NO-UNDO. DO i = 1 TO 20. DISPLAY i RANDOM(1, 20). PAUSE. ...

Python includes a profiler called cProfile. This is generally preferred over using timeit. It breaks down your entire script and for each method in your script it tells you: ncalls: The number of times a method was called tottime: Total time spent in the given function (excluding time made in c...

Better MID() and other string extraction examples, currently lacking from the web. Please help me make a good example, or complete this one here. Something like this: DIM strEmpty as String, strNull as String, theText as String DIM idx as Integer DIM letterCount as Integer DIM result as String ...

Write a CSV file from a dict or a DataFrame. import pandas as pd d = {'a': (1, 101), 'b': (2, 202), 'c': (3, 303)} pd.DataFrame.from_dict(d, orient="index") df.to_csv("data.csv") Read a CSV file as a DataFrame and convert it to a dict: df = pd.read_csv("data.csv&qu...