Tutorial by Examples: p

Foreign Keys constraints ensure data integrity, by enforcing that values in one table must match values in another table. An example of where a foreign key is required is: In a university, a course must belong to a department. Code for the this scenario is: CREATE TABLE Department ( Dept_Code...

To create a customization package replacing images on the login page, follow the steps below on your local Acumatica instance: Create a new folder in the Acumatica instance folder. For this example I added a folder called IconsCustomized in my local LoginImages instance: Add your custom ...

If you have a date stored as a string you will need to parse it. Use time.Parse. // time.Parse( format , date to parse) date, err := time.Parse("01/02/2006", "04/08/2017") if err != nil { panic(err) } fmt.Println(date) // Prints 2017-04-08 00:00:00 +00...

Creating app project When creating an Android app ready for the app store it's important when using ionic start that we add --appname|-a and --id|-i flags which is used for google play to identify your app from other apps. If you're starting a new mobile app project you can use the cli example b...

using System; using System.Collections.Generic; using System.Linq; using DocumentFormat.OpenXml; using A = DocumentFormat.OpenXml.Drawing; using DW = DocumentFormat.OpenXml.Drawing.Wordprocessing; using PIC = DocumentFormat.OpenXml.Drawing.Pictures; using DocumentFormat.OpenXml.Drawing.Wordpr...

Now open the document using OpenXML, you must add an imagePart that references the picture object to the MainDocumentPart object by using a file stream, and get the ID of the image string temp; MainDocumentPart mainPart = document.MainDocumentPart; ImagePart ima...

In office OpenXML, a picture that is inserted into a word document is considered a "Blip" Object or element. The class is derived from the DocumentFormat.OpenXml.Drawing the Blip must have an Embed value that is an imagePart ID. The Blip object then goes inside a BlipFill Object/element, a...

Now you have a reference of the image. Insert the image into the shapes in the template document. To do this, you will have to use some LINQ to iterate through the document and get a reference to all the shapes in the document. The wps:spPr element you see in the above XML code is the xml element fo...

Now that you have a collection of all the shape references in the document. Loop through the collection with a foreach, and through each iteration create a Blip object. Set the Blip object embed value to the picture ID reference you captured earlier from the image part. Also create a Stretch object...

Conditionals in Pug can evaluate statements in a manner similar to JavaScript. You can evaluate variables created in Pug, or those passed to it by your route (res.render, pug.renderFile, etc). index.js var authorized = true res.render("index", { authorized: authorized }); index...

You can choose to prepend an if or else operator with a dash, but it is not necessary. You will need to wrap the statement in parentheses, though (if you omit a dash, you do not need parentheses.) - var showLogin = false; - if (showLogin === true) .welcome Welcome back to our website! - else...

unless is the inverse operation of if in Pug. It is analogous to if !(statement). index.pug - var likesCookies = true; unless likesCookies === true h2 You don't like cookies :( else h2 You like cookies! index.pug output <h1>You like cookies!</h1> Note: else unless st...

For a class-less React component: function SomeComponent(props){ const ITEMS = ['cat', 'dog', 'rat'] function getItemsList(){ return ITEMS.map(item => <li key={item}>{item}</i>); } return ( <ul> {getItemsList()} ...

The string type allows you to store text, which is a series of characters. There are multiple ways to create strings. A literal string is created by writing the text between double quotes. text := "Hello World" Because Go strings support UTF-8, the previous example is perfectly valid. ...

Getting started with Ext JS 6. Prerequisite steps: Download Sencha Cmd 6 and install it with sencha command set in environment path variables. Download trail version of Sencha SDK (ext-6.2.1.zip) and unzip it.(on location D:\ext-6.2.1) System is ready to create Extjs 6 application. Create ...

Since you need to sort & rename the fields, the best option will be the Sort Component in the Data Flow task (like you mentioned) . If you only want to rename columns, then use the "Derived Column" component. The Sort component should look as follows: In my example, you can see the ...

Installation of a vmod requires an installed version of Varnish Cache, including the development files. Requirements can be found in the Varnish documentation. Source code is built with autotools: sudo apt-get install libvarnishapi-dev || sudo yum install varnish-libs-devel ./bootstrap # If run...

Taking the previous example, removing the x:Key element of the style applies the style to all buttons in the Application scope. <Style TargetType="{x:Type Button}"> <Setter Property="FocusVisualStyle" Value="{StaticResource FocusVisual}"/> ...

Note: This setup guide assumes that you have Java and Eclipse already installed on your machine. If you do not, download the latest version of the Java Development Kit (henceforth referred to as the JDK) and the latest version of Eclipse (Neon 3 at time of writing). Step One: Downloading LWJGL To...

Here we will see a simple example of using the MessagingCenter in Xamarin.Forms. First, let's have a look at subscribing to a message. In the FooMessaging model we subscribe to a message coming from the MainPage. The message should be "Hi" and when we receive it, we register a handler wh...