Tutorial by Examples: for

Reading XML form URL with Retrofit 2

We will use retrofit 2 and SimpleXmlConverter to get xml data from url and parse to Java class. Add dependency to Gradle script: compile 'com.squareup.retrofit2:retrofit:2.1.0' compile 'com.squareup.retrofit2:converter-simplexml:2.1.0' Create interface Also create xml class wrapper in our cas...

Android • Retrofit2

FOR ... NEXT in Z80 Assembly

The Z80 has a specific instruction to implement loop counts: DJNZstanding for "decrement B register and jump if not zero". So, B is the register of choice to implement loops on this processor. FOR...NEXT needs to be implemented "backwards", because the register counts down to zer...

Assembly Language • Flow Control

Custom completion block for Custom Methods

1- Define Your own custom Block typedef void(^myCustomCompletion)(BOOL); 2- Create custom method which takes your custom completion block as a parameter. -(void) customMethodName:(myCustomCompletion) compblock{ //do stuff // check if completion block exist; if we do not check it will ...

iOS • Block

Dotted syntax for pairs

There is a particular syntax that allow us to write cons cell in a more compact way than using the cons constructor. A pair can be written as such: '(1 . 2) == (cons 1 2) The big difference is that we can create pairs using quote. Otherwise, Scheme would create a proper list (1 . (2 . '())). T...

scheme • Syntax

How to setup a nested form in Ruby on Rails

The first to thing to have: a model that contains a has_many relation with another model. class Project < ApplicationRecord has_many :todos end class Todo < ApplicationRecord belongs_to :project end In ProjectsController: class ProjectsController < ApplicationController d...

Ruby on Rails • Nested form in Ruby on Rails

Configure DNS servers for domain name resolution

File: /etc/resolv.conf contains a list of DNS servers for domain name resolution Sample contents of the file: nameserver 8.8.8.8 # IP address of the primary name server nameserver 8.8.4.4 # IP address of the secondary name server In case internal DNS server you can validate if this server reso...

GNU/Linux • Network Configuration

Remove Binary Data from Form

Sometimes the crashes occur constantly in a single form or report, or occur only when printing. It is possible that the binary data within the form / report has become corrupt. Save the Form / Report object as text There are two undocumented functions. Application.SaveAsText and Application.Load...

ms-access • How to troubleshoot Access crashes

forms.html

<!DOCTYPE html> <html> <head> <base target="_top"> <script> setInterval( function () { document.getElementById('messages').innerHTML = 'Event Timer Fetching'; google.script.run .withSuccessHandler(onS...

google-apps-script • Google Web App Script To Auto Download From Google Drive

For Terminal Prowess & Power Users

Sublime Terminal. Terminal allows use to open your favourite terminal right at the current file or project location you are currently working on in Sublime Text, with handy keyboard shortcuts. It is available through Package Control. SideBar Enhancements. This plugin adds additional functio...

sublimetext3 • Essential Packages

OpenMP: Parallel For Loop

This example shows how to divide a loop into equal parts and execute them in parallel. // Splits element vector into element.size() / Thread Qty // and allocate that range for each thread. #pragma omp parallel for for (size_t i = 0; i < element.size(); ++i) element[i] = ... /...

C++ • Concurrency With OpenMP

Add formulas to a cell

//set the total value of cells in range A1 - A25 into A27 worksheet.Cells["A27"].Formula = "=SUM(A1:A25)"; //set the number of cells with content in range C1 - C25 into C27 worksheet.Cells["C27"].Formula = "=COUNT(C1:C25)"; //fill column K with the s...

epplus • Creating formulas and calculate ranges

Formula with multiple sheets

//set the total value of all cells in Sheet 2 into G27 worksheet.Cells["G27"].Formula = "=SUM('" + worksheet2.Name + "'!" + worksheet2.Dimension.Start.Address + ":" + worksheet2.Dimension.End.Address + ")"; //set the number of cells with conten...

epplus • Creating formulas and calculate ranges

Complete example with formulas

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create 2 WorkSheets ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); ExcelWorksheet worksheet2 = excelPackage.Workbook.Worksheets.Add("Sheet 2"); ...

epplus • Creating formulas and calculate ranges

Fastfile lane to build and install all flavors for given build type to a device

Add this lane to your Fastfile and run fastlane installAll type:{BUILD_TYPE} in command line. Replace BUILD_TYPE with the build type you want to build. For example: fastlane installAll type:Debug This command will build all flavors of given type and install it to your device. Currently, it doesn't...

Android • fastlane

IOS 10 Permission required for accessing Camera, Photo library ....

iOS 10 Now Requires User Permission to Access Media Library, Photos, Camera and other Hardware like these. The solution for this is to add their keys into info.plist with description for user that how we are using their data , iOS already required permissions to access microphone, camera, and m...

ios10 • iOS 10 - Changes in asking permissions of Camera,Photo Library causing application to crash

Using a local module for easier querying

To simplify your querying from ORACLE-DB, you may want to call your query like this: const oracle = require('./oracle.js'); const sql = "select 'test' as c1, 'oracle' as c2 from dual"; oracle.queryObject(sql, {}, {}) .then(function(result) { console.log(result.rows[0]['C...

Node.js • Node.js with Oracle

Saving this for use in nested functions / objects

One common pitfall is to try and use this in a nested function or an object, where the context has been lost. document.getElementById('myAJAXButton').onclick = function(){ makeAJAXRequest(function(result){ if (result) { // success this.className = 'success'; } }) }...

JavaScript • Context (this)

NSRegularExpression for mail validation

func isValidEmail(email: String) -> Bool { let emailRegEx = "[A-Z0-9a-z._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,4}" let emailTest = NSPredicate(format:"SELF MATCHES %@", emailRegEx) return emailTest.evaluate(with: email) } or you could use String extensio...

Swift Language • NSRegularExpression in Swift

Oracle SQL CASE statement in a Netsuite formula

Using a CASE statement, conditionally display an expression in the column based on values found in another column, a.k.a. “my kingdom for an OR”. In the example, the result is obtained when the status of the transaction is Pending Fulfillment or Partially Fulfilled: CASE DECODE( {status}, 'Pending ...

netsuite • Exploiting formula columns in saved searches

Customize the CSS (stylesheet) for a column by inserting a DIV element

'<div style="font-size:11pt">' || expression || '</div>'

netsuite • Exploiting formula columns in saved searches