Tutorial by Examples: 1

This guide is explicitly for PostgreSQL 9.1 or higher on linux machines. It uses the postgres extensions-feature that will greatly improve the import of extensions to an existing postgres-installation. If you have to work with an older version of postgres, please refer to the official documentations...

A number of the demonstration macros within this part requires a function which I will explain later. For the moment, please just copy GetFldrNames() to a suitable module. I use this function frequently and keep it, and other like it that I use in many different macros, in a module named “ModGloba...

You are an Outlook user and understand terms such as “email”, “received time”, “subject” and “Folder Pane”. You know how to access Outlook’s Visual Basic Editor and create a module. See Introduction Part 1 if necessary. You have at least a basic knowledge of VBA. I declare Subroutines and variab...

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.

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) ...

Incorrect code Public Sub DoSomething() DoSomethingElse "42?" End Sub Private Sub DoSomethingElse(foo As Date) ' Debug.Print MonthName(Month(foo)) End Sub Why doesn't this work? VBA is trying really hard to convert the "42?" argument into a Date value. When it ...

Incorrect code Sub DoSomething() Dim foo As Collection With foo .Add "ABC" .Add "XYZ" End With End Sub Why doesn't this work? Object variables hold a reference, and references need to be set using the Set keyword. This error occurs whenever ...

Open Visual Studio and Select File -> New Project Select AWS Lambda Project with Tests (.NET Core) Next the Select Blueprint screen will display. Select Empty Function and Click the Finish button: Go to Tools -> NuGet Package Manager -> Package Manager Console. In the console win...

A settings variable Default_Base is set on the instance of Ada.Text_IO.Integer_IO; also, Default_Width is set so that output cannot have leading space. with Ada.Text_IO; use Ada.Text_IO; procedure Print_Hex is subtype Count is Integer range -1_000_000 .. 1_000_000; package Count_IO...

This will take about 30 minutes. We will be setting Ruby on Rails Development Environment on Ubuntu 16.10 Yakkety Yak. Open up your terminal using Ctrl + Alt + T. Installing Ruby The First step is to install Dependencies For Ruby. sudo apt-get update sudo apt-get install git-core curl zlib1g-...

Download visual studio code from here Visual studio code. Select your target installer[mac|windows|linux]. Go to downloaded file in your local. Below steps in volved for installing Installation finished successfully.

/** * An example of nlapiLookupField to retrieve a single field from a related record */ // Get the Sales Rep record ID var repId = nlapiGetFieldValue("salesrep"); // Get the name of the Sales Rep var repName = nlapiGetFieldText("salesrep"); // Retrieve the email...

/** * An example of nlapiLookupField to retrieve multiple fields from a related record */ // Get the Sales Rep record ID var repId = nlapiGetFieldValue("salesrep"); // Retrieve multiple fields from the associated Sales Rep var repData = nlapiLookupField("employee", ...

/** * An example of nlapiLookupField to retrieve joined fields from a related record */ var repId = nlapiGetFieldValue("salesrep"); // Retrieve multiple fields from the associated Sales Rep var repData = nlapiLookupField("employee", repId, ["email", "f...

/** * A SuiteScript 1.0 example of using nlapiSubmitField to update a single field on a related record */ // From a Sales Order, get the Customer ID var customerId = nlapiGetFieldValue("entity"); // Set a comment on the Customer record nlapiSubmitField("customer", c...

/** * A SuiteScript 1.0 example of using nlapiSubmitField to update multiple fields on a related record */ // From a Sales Order, get the Customer ID var customerId = nlapiGetFieldValue("entity"); // Set a Comment and update the Budget Approved field on the Customer record nlap...

Given a normalized phone number like +178612345678 we will get a formatted number with the provided pattern. private String getFormattedNumber(String phoneNumber) { PhoneNumberUtil phoneNumberUtil = PhoneNumberUtil.getInstance(); Phonemetadata.NumberFormat numberFormat = new P...