Tutorial by Examples: me

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

In this layer we will write the application business. It is recommended for each presentation screen, you create the business interface and implementation class that contain all required functions for the screen. Below we will write the business for product screen as example /// <summary> ...

Combining change of character case with Enumeration_IO and using a text buffer for the image. The first character is manipulated in place. with Ada.Text_IO; use Ada.Text_IO; with Ada.Characters.Handling; use Ada.Characters.Handling; procedure Main is type Fruit is (Banana, Pear, Orange, Me...

Swift 3 import UIKit // Save String to file let fileName = "TextFile" let documentDirectory = try FileManager.default.urlForDirectory(.documentDirectory, in: .userDomainMask, appropriateFor: nil, create: true) var fileURL = try documentDirectory.appendingPathComponent(fileName).ap...

A common mistake MATLAB coders have, is using the length function for matrices (as opposed to vectors, for which it is intended). The length function, as mentioned in its documentation, "returns the length of the largest array dimension" of the input. For vectors, the return value of leng...

Step 1: Creating Custom Error Logging Filter which will write Errors in Text Files According to DateWise. public class ErrorLogger : HandleErrorAttribute { public override void OnException(ExceptionContext filterContext) { string strLogText = ""; Excepti...

In the IF THEN ELSE statement the result can be either a single statement: DEFINE VARIABLE i AS INTEGER NO-UNDO. IF i = 0 THEN MESSAGE "Zero". ELSE MESSAGE "Something else". Or a block, for instance by adding a DO-block: DEFINE VARIABLE i AS INTEGER NO...

Having local Class = {} Class.__meta = {__index=Class} function Class.new() return setmetatable({}, Class.__meta) Assuming we want to change the behavior of a single instance object = Class.new() using a metatable, there are a few mistakes to avoid: setmetatable(object, {__call = table.conca...

There are 2 ways to set formBuilder controls parameters. On initialize: exampleForm : FormGroup; constructor(fb: FormBuilder){ this.exampleForm = fb.group({ name : new FormControl({value: 'default name'}, Validators.compose([Validators.required, Validators.maxLength(15)])) }); ...

A procedure can have parameters of different kinds: input, output, input-output (bidirectional) and also some special types like temp-tables and datasets). In the run statement it's optional to declare INPUT (it's considered default) - all other directions must be specifically declared. A procedur...

Incorrect Code Sub DoSomething() GoSub DoThis DoThis: Debug.Print "Hi!" Return End Sub Why doesn't this work? Execution enters the DoSomething procedure, jumps to the DoThis label, prints "Hi!" to the debug output, returns to the instruction immediately afte...

Incorrect code Sub DoSomething() Dim row As Integer For row = 1 To 100000 'do stuff Next End Sub Why doesn't this work? The Integer data type is a 16-bit signed integer with a maximum value of 32,767; assigning it to anything larger than that will overflow the type and ...

Incorrect code Sub DoSomething() Dim foo(1 To 10) Dim i As Long For i = 1 To 100 foo(i) = i Next End Sub Why doesn't this work? foo is an array that contains 10 items. When the i loop counter reaches a value of 11, foo(i) is out of range. This error occurs whenever...

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

you can set a Jekyll environment and value, when build time JEKYLL_ENV=production jekyll b JEKYLL_ENV=production jekyll build JEKYLL_ENV=production bundle exec jekyll build if your code contains the bellow snippet, analytics.html will not be included unless your building with JEKYLL_ENV=...

Incorrect code Sub DoSomething() On Error GoTo CleanFail DoSomethingElse CleanFail: Debug.Print Err.Number Resume Next End Sub Why doesn't this work? If the DoSomethingElse procedure raises an error, execution jumps to the CleanFail line label, prints the error number, a...

In general, the code is placed in the module of a sheet. This is the Worksheet_SelectionChange event, which fires each time a different cell is selected in the active sheet. You can select "Worksheet" from the first drop-down menu above the code window, and "Selection_Change" fr...

In this example, one of two different ImageViews should be translated from the ChooserFragment to the DetailFragment. In the ChooserFragment layout we need the unique transitionName attributes: <ImageView android:id="@+id/image_first" android:layout_width="wrap_content...