Tutorial by Examples: re

COMMENT on TABLE student IS NULL; Comment will be removed with above statement execution.

private bool navigateFlag = false; protected async override void OnNavigatingFrom(NavigatingCancelEventArgs e) { base.OnNavigatingFrom(e); if (!navigateFlag) { e.Cancel = true; var dialog = new MessageDialog("Navigate away?", Confir,); ...

NSMutableAttributedString * string = [[NSMutableAttributedString alloc] initWithString:@"firstsecondthird"]; [string addAttribute:NSForegroundColorAttributeName value:[UIColor redColor] range:NSMakeRange(0,5)]; [string addAttribute:NSForegroundColorAttributeName value:[UIColor greenColo...

Let's say we have a form like the one below. We want to send the data to our webserver via AJAX and from there to a script running on an external server. So we have normal inputs, a multi-select field and a file dropzone where we can upload multiple files. Assuming the AJAX POST request was succ...

If a view is created WITH SCHEMABINDING, the underlying table(s) can't be dropped or modified in such a way that they would break the view. For example, a table column referenced in a view can't be removed. CREATE VIEW dbo.PersonsView WITH SCHEMABINDING AS SELECT name, address FROM d...

The easiest way to record a macro is the button in the lower left corner of Excel looks like this: When you click on this you will get a pop-up asking you to name the Macro and decide if you want to have a shortcut key. Also, asks where to store the macro and for a description. You can choose any ...

A data structure is a way of organizing and storing information. Let a "Hello, World!" string be the information that we need to organize and store in byte-addressable memory. Each ASCII character requires 7 bits of storage. Most systems reserve 8 bits (1 byte) for each character, so eac...

File: /etc/hosts contains a list of hosts that are to be resolved locally(not by DNS) Sample contents of the file: 127.0.0.1 your-node-name.your-domain.com localhost.localdomain localhost XXX.XXX.XXX.XXX node-name The file format for the hosts file is specified by RFC 952

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

IMPORTANT This is just an example code, do not use in production. In order to download an header chain we have to send a getHeaders message. In this example we will require as much as possible headers after the 40000th one.The peer will respond with batch of 2000 headers so, we have to take the la...

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

If you have images or other data stored in Access itself as OLE Objects, then you should find a better approach. When the OLE data is stored, it is stored according to the software (and version of software) on the computer storing it. When another computer goes to display that OLE Object data on the...

This is a lot of work, so do this as a last resort after exhausting all other options. You only need to do this if the problem is occurring for different users, on different machines. If it isn't occurring for all users, then most likely it is not a corrupt database container. Similar to the steps...

You can create new commands via php artisan make:command [commandName] So this will create [commandName] command class inside app/Console/Commands directory. inside this class you will find protected $signature and protected $description variables, it represents name and discription of your comma...

instance methods use an instance of a class. @interface MyTestClass : NSObject - (void)testInstanceMethod; @end They could then be used like so: MyTestClass *object = [[MyTestClass alloc] init]; [object testInstanceMethod]; Class method can be used with just the class name. @inte...

<?php $visit = 1; if(file_exists("counter.txt")) { $fp = fopen("counter.txt", "r"); $visit = fread($fp, 4); $visit = $visit + 1; } $fp = fopen("counter.txt", "w"); fwrite($fp, $visit); echo "Total Site Visits: &qu...

This example illustrates a concept to perform reduction or gathering using std::vector and OpenMP. Supposed we have a scenario where we want multiple threads to help us generate a bunch of stuff, int is used here for simplicity and can be replaced with other data types. This is particularly useful...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //the query or stored procedure name for the database string sqlQuery = "SELECT * FROM myTable"; //create a datatable DataTable dataTable = loadExternalDataSet(sqlQuery); //c...

used to get request information such as parameter, header information, remote address, server name, server port, content type, character encoding. Index.html <form action="req.jsp"> <input type="text" name="username"> <input type="s...

Using private repos working with yarn caveat: This works using npm: "common-js": "[email protected]:<user-name>/<repo-name>.git#<identifier>" but will not work using yarn. This change is required: "common-js": "git+ssh://[email protected]:&...