Tutorial by Topics: s

This code will turn off the capability for a user to hold down the Shift key when opening a database to skip the default form opening and allow the user access to the Navigation Pane and VB Editor. In DB’s that you do not want users to have access to either of these (along with disabling the use ...

Log.v(String tag, String msg, Throwable tr) Log.v(String tag, String msg) Log.d(String tag, String msg, Throwable tr) Log.d(String tag, String msg) Log.i(String tag, String msg, Throwable tr) Log.i(String tag, String msg) Log.w(String tag, String msg, Throwable tr) Log.w(String tag, String...

As database tables grow, it's often useful to limit the results of queries to a fixed number or percentage. This can be achieved using SQL Server's TOP keyword or OFFSET FETCH clause. ParameterDetailsTOPLimiting keyword. Use with a number.PERCENTPercentage keyword. Comes after TOP and limiting ...

A set is a collection of items which can be anything. Whatever operator we need to work on these sets are in short the set operators and the operation is also known as set operation. Basic set operation includes Union, Intersection as well as addition, subtraction, etc. Group-Object Gr...

ParameterDescriptionpath_or_bufstring or file handle, default None File path or object, if None is provided the result is returned as a string.sepcharacter, default ‘,’ Field delimiter for the output file.na_repstring, default ‘’ Missing data representationfloat_formatstring, default None Format st...

TypeScript, like ECMA Script 6, support object-oriented programming using classes. This contrasts with older JavaScript versions, which only supported prototype-based inheritance chain. The class support in TypeScript is similar to that of languages like Java and C#, in that classes may inherit fro...

import itertools

my # Lexical declaration our # Global declaration $foo # Scalar @foo # Array $#foo # Array Last-Index %foo # Hash ${$foo} # Scalar De-Reference @{$foo} # Array De-Reference $#{$foo} # Array-DeRef Last-Index %{$foo} # Hash De-Reference $foo[$index] # Array get indexed ${$foo}[$inde...

For more information, visit the official documentation at http://getbootstrap.com/javascript/#carousel, where the basic HTML and Javascript usage examples and information are derived from. It should be noted that carousels do not function correctly in IE 9 and earlier due to the use of CSS3 trans...

The global.json file is extremely powerful and unique to .NET Core and ASP.NET Core applications.

xmlns:fx="http://javafx.com/fxml"       // namespace declaration

NodeClass /* selector by Node's class */ .someclass /* selector by class */ #someId /* selector by id */ [selector1] > [selector2] /* selector for a direct child of a node matching selector1 that matches selector2 */ [selector1] [selector2] /* selector for a descendant of a node matching se...

With pthreads v3 pthreads can only be loaded when using the cli SAPI, thus it is a good practice to keep the extension=pthreads.so directive in php-cli.ini ONLY, if you are using PHP7 and Pthreads v3. If you are using Wamp on Windows, you have to configure the extension in php.ini : Open php...

To select rows with out duplicates change the WHERE clause to "RowCnt = 1" To select one row from each set use Rank() instead of Sum() and change the outer WHERE clause to select rows with Rank() = 1