Tutorial by Examples: io

A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators. Create table with a computed column Create table NetProfit ( Sa...

Sometimes, one wants to run some initialization code once before testing a condition. In certain other languages, this kind of loop has special do-while syntax. However, this syntax can be replaced with a regular while loop and break statement, so Julia does not have specialized do-while syntax. Ins...

A lot of people who are new to multi-threading think that using threads automatically make an application go faster. In fact, it is a lot more complicated than that. But one thing that we can state with certainty is that for any computer there is a limit on the number of threads that can be run at ...

When programming in Prolog it is not always possible, or desirable, to create predicates which unify for every possible combination of parameters. For example, the predicate between(X,Y,Z) which expresses that Z is numerically between X and Y. It is easily implemented in the cases where X, Y, and Z ...

Increase the saturation level of an image with ctx.globalCompositeOperation = 'saturation'; The amount of the effect can be controled with the alpha setting or the amount of saturation in the fill overlay // Render the image ctx.globalCompositeOperation='source-atop'; ctx.drawImage(image, 0, ...

Detailed instructions on getting wordpress-theming set up or installed. Wordpress is opensource.You can find large set of theme for use free or premium themes.All theme are provide a documentation for install and use. What you have to understand while choose a theme? Wordpress version you are ...

Excel formulas are used to process simple or complex equations and output the result to a specific cell within a worksheet. (There is an exception to this where the WorksheetFunction class is used in VBA programming, however VBA is out of scope for this tag - please refer to the excel-vba or vba ...

Html5 Canvas gives you the ability to fetch and change the color of any pixel on the canvas. You can use Canvas's pixel manipulation to: Create a color-picker for an image or select a color on a color-wheel. Create complex image filters like blurring and edge detection. Recolor any part of an ...

Unwind Segues Unwind Segues give you a way to “unwind” the navigation stack and specify a destination to go back to. The signature of this function is key to Interface Builder recognizing it. It must have a return value of IBAction and take one parameter of UIStoryboardSegue. The name of the ...

Description: phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, ...

You can use the heroku create command to create a Heroku application. Each application you deploy to Heroku has its own code base, environment variables, addons, etc. Each Heroku application has a globally unique name. If you try to create a Heroku application whose name is already taken, you will ...

This example demonstrates usage of lockf function (POSIX XSI). Notes: Only exclusive locks are supported. Can be applied to a byte range, optionally automatically expanding when data is appended in future (controlled by len argument and position set with lseek function). Locks are released on ...

CKContainer.defaultContainer().accountStatusWithCompletionHandler { accountStatus, error in if accountStatus == .NoAccount { let alert = UIAlertController(title: "Sign in to iCloud", message: "Sign in to your iCloud account to write records. On the Home screen, l...

This example shows how to use fast enumeration in order to traverse through an NSArray. When you have an array, such as NSArray *collection = @[@"fast", @"enumeration", @"in objc"]; You can use the for ... in syntax to go through each item of the array, automatical...

https://godzillai5.wordpress.com/2016/08/20/db2-for-i-in-the-cloud-connecting-to-pub400-via-jdbc-in-netbeans/

https://godzillai5.wordpress.com/2016/08/21/jdbc-jt400-setting-to-get-crud-and-show-sql-features-added-in-netbeans-with-ibm-db2-for-i/

MainActivity.java: public class MainActivity extends AppCompatActivity { @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); } } activity_main.xml: <?xml version="1...

Union operation combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union and will ignore any duplicates that exist. Union all also does the same thing but include even the duplicate values. The concept of union operation ...

This will get all the orders for all customers: SELECT c.CustomerName, o.OrderID FROM Customers AS c INNER JOIN Orders AS o ON c.CustomerID = o.CustomerID ORDER BY c.CustomerName, o.OrderID; This will count the number of orders for each customer: SELECT c.CustomerName, C...

Detailed instructions on getting ssrs-2008-r2 set up or installed.